Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup column using text not col number
The normal vlookup uses a column index number to select the column for your
result. I am trying to do a table lookup with a value that would find a different column based on input. This lookup would be in many places in a spreadsheet and at somepoint someone will probably change the column arrangement. There are different pricing policies in effect ie 1, 2, 3, etc. So at times i want to find the column for price1, price2 or price3. So price1 is in col 6 but sometime might get moved to col 8. And I would prefer the lookup formula move with it. If you do calculations inside a table there are commands with [] that use the column name. Can that be done outside a table? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup column using text not col number
Joe wrote:
The normal vlookup uses a column index number to select the column for your result. I am trying to do a table lookup with a value that would find a different column based on input. This lookup would be in many places in a spreadsheet and at somepoint someone will probably change the column arrangement. There are different pricing policies in effect ie 1, 2, 3, etc. So at times i want to find the column for price1, price2 or price3. So price1 is in col 6 but sometime might get moved to col 8. And I would prefer the lookup formula move with it. If you do calculations inside a table there are commands with [] that use the column name. Can that be done outside a table? http://www.contextures.com/xlFunctio...ml#IndexMatch3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup missing number(s) in column w/blanks & duplicates | Excel Worksheet Functions | |||
Excel 2002: How to lookup the last number and text in a column ? | Excel Discussion (Misc queries) | |||
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
lookup text in one column, count in another column | Excel Worksheet Functions | |||
Find Column Number via Lookup | Excel Worksheet Functions |