Match Column B numbers to Column A numbers

[Bad_manager]

I have a long list of numbers is Column A; I have a second extra long list of
similar numbers in column B. How do I play find your Mate? M001 in Column B
finds M001 in Column A. What if my Column B list has more than 1 M001? Will
that effect the outcome?

[Magnivy]

You can try using the VLOOKUP or the LOOKUP function. If Column B has more
than 1 M001, these function will return the first one.

"Bad_manager" wrote:

> I have a long list of numbers is Column A; I have a second extra long list of
> similar numbers in column B. How do I play find your Mate? M001 in Column B
> finds M001 in Column A. What if my Column B list has more than 1 M001? Will
> that effect the outcome?