Hi all, so I have a problem...
I have two spreadsheets, Spreadsheet 1 contains like 3000+ text data while Spreadsheet 2 contains 300 text data. Spreadsheet 2 is a part of Spreadsheet 1, and I have the task to highlight the 300 from Spreadsheet 2 in Spreadsheet 1, like creating a new column called "Status" in the right side. The contents in Spreadsheet 1 which are in Spreadsheet 2 will be marked as "Done" in the "Status" column.
The thing is, I don't really know how to do this. I used VLOOKUP and it fails. I also tried IFNA and MATCH but it doesn't show what I wanted...
Please help me.
Thank you. I hope you all have a great day!
Bookmarks