From: Zuo on
Thank you to both it works.

"Rick Rothstein" wrote:

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