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