The range that you are using $A:$AQ is 43 columns, but your formula is asking
to return info from the 44 column just outside the range, adjust the range to
$A:$AR so that 44 will work.

"Gee..." wrote:

Why won't this work:

VLOOKUP($A$4,INDIRECT(CONCATENATE("'",C$2,"'!$A:$A Q"),1),44,FALSE)

When I use ",43,FALSE) and any other column before that it works fine...but
it returns a #REF past 43...another Excel quirk?

Thank you in advance for your help.