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


.