| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - Column number
Hi,
I'm trying to get my VLOOKUP function to work but am having difficulty. This is my formula and it is returning the correct answer but I actually want data from column 52 not 46. When I change the column number to anything 47 or above the function returns 0 when there is data in the relevant columns (and it's not 0) =VLOOKUP(BJ6,B5:BH14,46,TRUE) Are there limits to th number of columns that can be referenced to in a VLOOKUP function or am I missing something? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I automatically update column index number in VLookup whe. | Excel Worksheet Functions | |||
| Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
| how i write a number on a column A and see that number on letters. | Excel Worksheet Functions | |||
| Multiple Column Index Number in VLookup | Excel Worksheet Functions | |||
| Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
Threaded Mode
