From: Zuo on
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

From: Rick Rothstein on
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" <Zuo(a)discussions.microsoft.com> wrote in message
news:F6225750-C572-44A1-A914-083DFF38A1FC(a)microsoft.com...
> 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
>

From: Max on
In B1: 3256
In C1: ="A"&MATCH(B1,A:A,0)
will return "A3"
--
Max
Singapore
---
"Zuo" wrote:
> 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
>