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
.
|