Match Column B numbers to Column A numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to filter list based on multiple criteria 1
adding 1 to each following cells with a prefix 5
With F1 value, look at A, if match or partial match return B 5
How to count the maximum number flanked by zeros 9
Calculate total by row number 4
Copy corresponding cell in Column B if cell in A contains certain text? 1
column A matches f places the value from g in column b what funct 2
Matching 2 columns 3

Back
Top