Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Last answered:

04 Feb 2023

Posted on:

03 Feb 2023

0

Resolved: Choosing =INDIRECT("C6") vs. =INDIRECT("C"&6)

I know they both output the staff of Company A and I know why they do, you can also change the row and column of both versions to give a different output, so is choosing one or the other just a personal preference, or is one version better in some situations?

1 answers ( 1 marked as helpful)
Instructor
Posted on:

04 Feb 2023

0

Hi Dylan,

It doesn't really make a difference because the input INDIRECT needs is text. 

Best,

Ned

Submit an answer