Suppose your data range in Columnn A:J...The below formula will lookup for
'Steve' in ColA and search for a value of 5 i that row and return the header
of that column...from row 1

=INDEX(A1:J1,MATCH(5,OFFSET(A1:J1,MATCH("Steve",A: A,0)-1,0)))

If this post helps click Yes
---------------
Jacob Skaria


"Steve Haack" wrote:

I have a table with Row Headings (Names) down the left side, and column
headings across the top.

I want to do a lookup on the name (like a VLOOKUP), but then I want to
search across the row where I found the name and look for a specific value,
and then return the column name.

How would I do that?

Thanks,
Steve