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

in Advanced Microsoft Excel / Advanced Excel Functions Indirect; Vlookup & Indirect

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)

Ned Krastev

Instructor

Posted on:

04 Feb 2023

Hi Dylan,

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

Best,

Ned

Helpful answer

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

Submit an answer

related questions