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

  • Thread starter Thread starter Zuo
  • Start date Start date
Z

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
 
This maybe...

=MATCH(3256,A1:A100,0)

Although I would probably use a cell reference in place of the hard-coded
3256 value.
 
Thank you to both it works.

Rick Rothstein said:
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)




.
Click to expand...
 
Back
Top