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

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

Try this...

B1:F1 = column headers
A2:A10 = row headers = names

A15 = lookup name
B15 = lookup_value

=INDEX(B1:F1,MATCH(B15,INDEX(B2:F10,MATCH(A15,A2:A 10,0),0),0))

--
Biff
Microsoft Excel MVP


"Steve Haack" wrote in message
...
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

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


http://www.contextures.com/xlFunctio...ml#IndexMatch2

Glenn wrote:
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


http://www.contextures.com/xlFunctio...ml#IndexMatch2


Sorry, didn't completely comprehend the question. However, the resource is
still useful!