Thread: Match Column B numbers to Column A numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Magnivy Magnivy is offline
external usenet poster
  
Posts: 70
Default 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?
Reply With QuoteReply With Quote