hlookup within a conditional function

[amihalko]

I have a list of values in one row on a spreadsheet and would like to
scan that row to find a match within that row to a specified cell.
When the match is found I would like to have the corresponding text
displayed. That text is located in the row directly above the values.

I have tried a conditional statement: (entered as an array)

{=If(C4=D4:L4, D3:L3,0)}

I think this is pretty simply but I am missing something. Do I need to
include an HLOOKUP as well? (The formula above does not recognize the
row as the arguement only the first cell within the range. For example
is only recognizes D4 not the range between D4 and L4.)

 

[Jason Morin]

=INDEX(D3:L3,MATCH(C4,D4:L4,0))

HTH
Jason
Atlanta, GA