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?

Hi Dylan, It doesn't really make a difference because the input INDIRECT needs is text. Best, Ned

Follow this topic