Lookup Formula question

[Steve Haack]

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

 

[Jacob Skaria]

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

 

[T. Valko]

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:A10,0),0),0))

 

[Glenn]

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/xlFunctions03.html#IndexMatch2

 

[Glenn]

http://www.contextures.com/xlFunctions03.html#IndexMatch2

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