Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I compare two lists and choose the items that are in both?
I have a list of 2200 things, and a list of 45,000 things. The list of
45,000 things has other numbers that I want, so I want to isolate the 2200 things from the list of 45,000 things. Does vlookup or hlookup or match or choose work for this? I'm using Excel from Microsoft Office 2004 for Mac. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Font Size in Drop Down Lists (e.g. AutoFilter) | Excel Discussion (Misc queries) | |||
Drop Down Lists - Not allowing other contents to be put in same ce | Excel Worksheet Functions | |||
IF statement with lists and dropdowns | Excel Worksheet Functions | |||
Adding entry to validation list without retyping all lists | Excel Discussion (Misc queries) | |||
Dependent lists | Excel Worksheet Functions |