| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP use column name not number
Is there a way to use VLOOKUP to search for a column name and return the
value in that column, rather search for a column number. -- Thank you, Kathy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP use column name not number
kathy wrote:
Is there a way to use VLOOKUP to search for a column name and return the value in that column, rather search for a column number. Use INDEX/MATCH. Look he http://www.contextures.com/xlFunctio...ml#IndexMatch2 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP use column name not number
Something like this...
=VLOOKUP("this",A:J,MATCH("column_name",A1:J1,0),0 ) -- Biff Microsoft Excel MVP "kathy" wrote in message ... Is there a way to use VLOOKUP to search for a column name and return the value in that column, rather search for a column number. -- Thank you, Kathy |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP use column name not number
One method.
Assuming names are titles in row 1 of a lookup table of range A1:F10 InsertNameDefine Type the title name from A1.....gord Refers to =1 Add........type the title name from B1.......kathy Refers to =2 Do for each name in A1:F1 Formula in H1 =VLOOKUP(G1,$A$1:$F$10,kathy,FALSE) Note: if spaces in names like gord dibben, use gord_dibben Gord Dibben MS Excel MVP On Tue, 11 May 2010 10:34:02 -0700, kathy wrote: Is there a way to use VLOOKUP to search for a column name and return the value in that column, rather search for a column number. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP use column name not number
=VLOOKUP(A4,History1!B1:BU218,MATCH('Income
Variance'!B3,History1!B1:BU197,0),0) I tried this and get #N/A. A4 is the row name that is to be looked up. history1 B1:bu218 is the worksheet name to find the data on 'income variance'! B3 is the column title to be looked up('income variance' is the name of the worksheet that is looking for the information) history1 B1:bu218 is the worksheet with the data on it again Am I missing something? -- Thank you, Kathy "T. Valko" wrote: Something like this... =VLOOKUP("this",A:J,MATCH("column_name",A1:J1,0),0 ) -- Biff Microsoft Excel MVP "kathy" wrote in message ... Is there a way to use VLOOKUP to search for a column name and return the value in that column, rather search for a column number. -- Thank you, Kathy . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP use column name not number
...MATCH('Income Variance'!B3,History1!B1:BU197,0)...
The lookup_array argument in MATCH must be a one dimenonsional array. Try it like this... =VLOOKUP(A4,History1!B1:BU218,MATCH('Income Variance'!B3,History1!B1:BU1,0),0) -- Biff Microsoft Excel MVP "kathy" wrote in message ... =VLOOKUP(A4,History1!B1:BU218,MATCH('Income Variance'!B3,History1!B1:BU197,0),0) I tried this and get #N/A. A4 is the row name that is to be looked up. history1 B1:bu218 is the worksheet name to find the data on 'income variance'! B3 is the column title to be looked up('income variance' is the name of the worksheet that is looking for the information) history1 B1:bu218 is the worksheet with the data on it again Am I missing something? -- Thank you, Kathy "T. Valko" wrote: Something like this... =VLOOKUP("this",A:J,MATCH("column_name",A1:J1,0),0 ) -- Biff Microsoft Excel MVP "kathy" wrote in message ... Is there a way to use VLOOKUP to search for a column name and return the value in that column, rather search for a column number. -- Thank you, Kathy . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP use column name not number
Thank you, that worked!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
-- Thank you, Kathy "T. Valko" wrote: ...MATCH('Income Variance'!B3,History1!B1:BU197,0)... The lookup_array argument in MATCH must be a one dimenonsional array. Try it like this... =VLOOKUP(A4,History1!B1:BU218,MATCH('Income Variance'!B3,History1!B1:BU1,0),0) -- Biff Microsoft Excel MVP "kathy" wrote in message ... =VLOOKUP(A4,History1!B1:BU218,MATCH('Income Variance'!B3,History1!B1:BU197,0),0) I tried this and get #N/A. A4 is the row name that is to be looked up. history1 B1:bu218 is the worksheet name to find the data on 'income variance'! B3 is the column title to be looked up('income variance' is the name of the worksheet that is looking for the information) history1 B1:bu218 is the worksheet with the data on it again Am I missing something? -- Thank you, Kathy "T. Valko" wrote: Something like this... =VLOOKUP("this",A:J,MATCH("column_name",A1:J1,0),0 ) -- Biff Microsoft Excel MVP "kathy" wrote in message ... Is there a way to use VLOOKUP to search for a column name and return the value in that column, rather search for a column number. -- Thank you, Kathy . . |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP use column name not number
Good deal. Thanks for the feedback!
-- Biff Microsoft Excel MVP "kathy" wrote in message ... Thank you, that worked!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! -- Thank you, Kathy "T. Valko" wrote: ...MATCH('Income Variance'!B3,History1!B1:BU197,0)... The lookup_array argument in MATCH must be a one dimenonsional array. Try it like this... =VLOOKUP(A4,History1!B1:BU218,MATCH('Income Variance'!B3,History1!B1:BU1,0),0) -- Biff Microsoft Excel MVP "kathy" wrote in message ... =VLOOKUP(A4,History1!B1:BU218,MATCH('Income Variance'!B3,History1!B1:BU197,0),0) I tried this and get #N/A. A4 is the row name that is to be looked up. history1 B1:bu218 is the worksheet name to find the data on 'income variance'! B3 is the column title to be looked up('income variance' is the name of the worksheet that is looking for the information) history1 B1:bu218 is the worksheet with the data on it again Am I missing something? -- Thank you, Kathy "T. Valko" wrote: Something like this... =VLOOKUP("this",A:J,MATCH("column_name",A1:J1,0),0 ) -- Biff Microsoft Excel MVP "kathy" wrote in message ... Is there a way to use VLOOKUP to search for a column name and return the value in that column, rather search for a column number. -- Thank you, Kathy . . |
| Reply |
| 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 | |||
| vlookup column index number argument | Excel Worksheet Functions | |||
| VLOOKUP - Column number | Excel Discussion (Misc queries) | |||
| Multiple Column Index Number in VLookup | Excel Worksheet Functions | |||
| Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
Linear Mode
