I'm struggling to find an answer to my problem. My problem is that I have a column of unique identifiers (Excel File A). On a separate excel file (Excel File B) I have the same unique identifiers but some are missing or are not relevant in this file.
I need to take the data in Excel File B and match them to Excel File A. But I can't simply copy and paste because they're not in the same order and some are missing.
How do I solve this?
2 Answers
You will need to follow a few steps:
- insert
=match(symbol, List looking at,0)in the column that you are looking to try to filter - go to the data tab an select filter
- click on the drop down and unselect #NA (and any you don't want to copy)
- select all of the filtered results and copy them
- paste them where you would like.
=Vlookup('Excel File A!A1','Excel File B!A:A',1,FALSE)
Vlookup
1. First Part = What your looking for
2. Second Part = Column you are looking in
3. Third Part = Column number to look in
4. Fourth Part = FALSE means EXACT MATCH
First Workbook
Second Workbook
Formula
Result
