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

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

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

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

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

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

Finding the cell loacation that matches a specific value in a
 

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


.