Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column index number
I am using the following formula:
=VLOOKUP($C$2,PKG!A2:BN2000,34,FALSE) This formula works for columns 1-12. After that, it doesn't give me the correct information. Is there a way to see the column number to be certain I am putting the right column number in? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column index number
In general
=COLUMN(AB1)-COLUMN(D1)+1 will give you the index number of Column AB when your data ranges starts at col D. If it starts at Col A then you can simply use =Column(AB1) since Column(A1) is one "helpwanted" wrote: I am using the following formula: =VLOOKUP($C$2,PKG!A2:BN2000,34,FALSE) This formula works for columns 1-12. After that, it doesn't give me the correct information. Is there a way to see the column number to be certain I am putting the right column number in? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column index number
One way:
In the column you're targeting, enter =COLUMN() (Alternatively, you could check the R1C1 Reference style checkbox in Tools/Options/General). Since the A1-style designations recycle every 26 letters, column 34 (=26 + 8) would be column AH. In article , helpwanted wrote: I am using the following formula: =VLOOKUP($C$2,PKG!A2:BN2000,34,FALSE) This formula works for columns 1-12. After that, it doesn't give me the correct information. Is there a way to see the column number to be certain I am putting the right column number in? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup column index number argument | Excel Worksheet Functions | |||
Lookup funtion: column index number (third parameter) | Excel Worksheet Functions | |||
Multiple Column Index Number in VLookup | Excel Worksheet Functions | |||
How to automatically number an index column | Excel Worksheet Functions | |||
having one more than one column index number | Excel Worksheet Functions |