|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 11th, 2010, 06:34 PM
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
May 11th, 2010, 06:39 PM
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
May 11th, 2010, 06:46 PM
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
May 11th, 2010, 07:05 PM
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
May 11th, 2010, 08:34 PM
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
May 11th, 2010, 09:03 PM
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
May 11th, 2010, 10:10 PM
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
May 12th, 2010, 01:45 AM
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 . .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
