Return Cell Address After Match

[ed9213]

This doesn't appear to be a new subject, but the solutions I've found don't seem to work for me.

I have a range of approximately 200 unique alphanumeric entries in column A.

I have new entries in column B and want to verify if there are any matching entries in column A.

The formula isn't a simple match; I want the result to point to the cell that has the match. So, near the entry in column B that is the specified item, if there is a match I would like to see the cell location in column A that holds it.

There must be a way to do this, but I can't seem to get this resolved by myself.

Thanks.

ed9213

 

[Fluff]

Glad we could help & thanks for the feedback