Search for a number in a column

[bhokalivarun]

I have numbers stored a column like:

A1 100
A2 200
A3 300
A4 400
A5 500

i want to search for 100 and should get A1 in return. Is there a commad to do this?

Thanks
Varun

[bigmack]

If data is located in 2 columns as shown below, and in cell C1 you can enter a lookup value

A B C
--- --- ---
A1 100 C1
A2 200
A3 300
A4 400
A5 500

Then you can try this formula:

Please Login or Register  to view this content.

MATCH returns the position, while INDEX returns the value.

[mubashir aziz]

Just put B1=100 or 200 or 300 and you will get the A1, A2 or A3

Formula is
C1="A"&(MATCH(B1,A1:A80))