Finding the cell loacation that matches a specific value in a rang

[Zuo]

Hi,

I have a list of references in column A going from A3:A240. I need a
formula that can find a specific reference within that range and give me back
the location of the reference.

Example:

A1 7569
A2 1245
A3 3256
A4 7895

If I input 3256 it needs to return either A3 or 3.

Thanks,

ZUO

 

[Rick Rothstein]

This maybe...

=MATCH(3256,A1:A100,0)

Although I would probably use a cell reference in place of the hard-coded
3256 value.

 

[Max]

In B1: 3256
In C1: ="A"&MATCH(B1,A:A,0)
will return "A3"

 

[Zuo]

Thank you to both it works.

This maybe...

=MATCH(3256,A1:A100,0)

Although I would probably use a cell reference in place of the hard-coded
3256 value.

--
Rick (MVP - Excel)




.