This might help about column limits:
http://www.mrexcel.com/board2/viewto...t=column+limit
This is a discussion on excel vlookup column limit? within the Excel Questions forums, part of the Question Forums category; Is there a limit to the number of columns one can reference in excel Vlookup? I can get numbers from ...
Is there a limit to the number of columns one can reference in excel Vlookup? I can get numbers from a table up to 26 columns but when I try to get any other column greater than 26 I get the #REF error. Thank you Happy new year!
This might help about column limits:
http://www.mrexcel.com/board2/viewto...t=column+limit
"Don't Ruin an Apology with an Excuse"...
santeria...I really don't see how a thread about the limitations of XL's column count corresponds to the OP's questions about VLookups?Originally Posted by santeria
As far as the OP's question...from what I've seen there is not a "limitation" on the column that a VLookup can return. If you are getting a #REF error, it is because you are trying to return a column outside of your table_array.
For example...
******** ******************** ************************************************************************>
Microsoft Excel - Book5 ___Running: 11.0 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
=
A B C D 1 3 * Tommy 3 2 #REF! * MrExcel 1 3 * * Aladin 2
Sheet1 *
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
The formula in A1 is =VLOOKUP("Tommy",C1:D3,2)
The formula in A2 is =VLOOKUP("Tommy",C1:D3,3)
Now, the second formula is returning an error because I am trying to return column 3 of a table that only contains 2 columns.
Also...this is quoted directly from the XL Help documentation...Originally Posted by Microsoft Excel Help
I had thought so, but obviously I was wrong ...
santeria...I really don't see how a thread about the limitations of XL's column count corresponds to the OP's questions about VLookups? [/quote]Originally Posted by TommyGun
"Don't Ruin an Apology with an Excuse"...
Thank you for the help everyone-problem is resolved I expanded the vlookup range as recommended in replies. Happy New Year!
Like this thread? Share it with others