Match Column B numbers to Column A numbers
 

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?

Match Column B numbers to Column A numbers
 

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?