43 Columns

[Gee...]

Why won't this work:

VLOOKUP($A$4,INDIRECT(CONCATENATE("'",C$2,"'!$A:$AQ"),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.

 

[Trevor Shuttleworth]

Gee

because $A:$AQ is only 43 columns. You are trying to extract data from the
44th column of a 43 column table.

Change it to $A:$AR and it should work. Just don't try to get column 45 !

Regards

Trevor

 

[Jimbola]

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.