Lookup Value

[Ruan]

I am trying to lookup a value without using the vlookup or hlookup
functions, as I am unable to. My data range is in A12. I need to find the
corresponding value in row 1 from the lookup_value in row 2.

Example:

45 60 35 79
AA BB CC DD

The lookup_value is CC. I need the result to be 35.

vlookup and hlookup cannot be used in this case. What are my alternatives?

Ruan

 

[T. Valko]

Try this:

A5 = CC

=INDEX(A11,MATCH(A5,A22,0))

 

[FARAZ QURESHI]

Try this out:
=OFFSET($A$1,0,MATCH("CC",$A$2:$D$2,0)-1)