Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Lookup Data in Several Columns | Excel Worksheet Functions |