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)


"Zuo" wrote in message
...
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