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.

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


"Gee..." wrote in message
...
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.

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.