For unsorted data...

=INDEX(ReturnRange,MATCH(Value,MatchRange,0))

For example:

=INDEX(A:A,MATCH(E2,C:C,0))

where E2 houses a value you want to look up.

via135 wrote:
hi!

i am having data in A1:C5.
can i findout the value in COL "A" or COL "B"
corresponding to my lookup value in COL "C"-?

hlp pl!?

-via135