Thread: VLOOKUP (or other formula) Across Two Spreadsheets

Right, ladies and gents, I've got a bit of an issue with Excel 2007 ( haven't all of us here? :p ) and I'd really like some help with it.

I've got a spreadsheet with a postcode in it and another spreadsheet with a postcode in. These are the only two matching bits of data between the spreadsheets.

In the first spreadsheet, there're about 12,000 row entries. In the second spreadsheet, there're about 8000.

I want to know if it's possible to have all the matching postcodes highlighted (preferably in their own column so I can just filter it) so I can clear out all the non-matching data. Any help you could give on this would be great.

TL;DR: I need to get matching data (across two spreadsheets) to be shown as coloured or with it's own value in another column.

Thanks in advance,
Bob

Originally Posted by Domski

Something like this:

=ISNUMBER(MATCH(A1,8000_List_Range,0))

Copied down the column next to your list of 12000 post codes will return TRUE if the value is in the other list.

Dom

Thank you very much! I had to have the 8000 list target the specific column, but it worked!

Thank you for this!