Find cell cell location from another list.

[tronsmith]

Hello everyone.

I am wondering if someone could help with a quick issue I am having.

I have two columns of data, column A contains a large array of data on many rows, column B is a shorter list but everything in there is somewhere in Column A.

What I would appreciate is a forumla that returns the cell location of the data that's in B1 in the range A$1:A13000

Thank you in advance.

Rep will be your reward.

Ryan.

[sweep]

Hi,

In C1 and copied down,

=ADDRESS(MATCH(B1,$A$1:$A$13000,0),1)

[brokenbiscuits]

=address(match(b1,a$1:a$13000,0),1)