Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
Adding a column of numbers, with a condition | New Users to Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
How to sum top 5 numbers from the column of numbers | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions |