| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup Functions
I am using the Vlookup function looking up values in a Pivot Table. The
problem I have is the column that I want to return is continuously changing. i.e the col_index_num one day maybe 12 and the next it may be 13 and so on as the pivot table grows. Does anyone know how I can make the col_index_num change. If it helps the column that I want to bring in has a constant heading? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLookup Functions
Use the Match function to search the title row for the name. It will return the column number... =MATCH("Total",2:2,0) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Monica" wrote in message I am using the Vlookup function looking up values in a Pivot Table. The problem I have is the column that I want to return is continuously changing. i.e the col_index_num one day maybe 12 and the next it may be 13 and so on as the pivot table grows. Does anyone know how I can make the col_index_num change. If it helps the column that I want to bring in has a constant heading? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLookup Functions
Awesome Thankyou
"Jim Cone" wrote: Use the Match function to search the title row for the name. It will return the column number... =MATCH("Total",2:2,0) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Monica" wrote in message I am using the Vlookup function looking up values in a Pivot Table. The problem I have is the column that I want to return is continuously changing. i.e the col_index_num one day maybe 12 and the next it may be 13 and so on as the pivot table grows. Does anyone know how I can make the col_index_num change. If it helps the column that I want to bring in has a constant heading? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| $ for VLOOKUP functions | Excel Worksheet Functions | |||
| VLOOKUP and IF Functions | Excel Worksheet Functions | |||
| if and vlookup functions | New Users to Excel | |||
| How do I add vlookup functions together | Excel Discussion (Misc queries) | |||
| Using VLOOKUP, IF and RIGHT functions together | Excel Worksheet Functions | |||
Linear Mode
