43 Columns
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.
|