Excel 2007 : How to compare two columns and identify which values match?

Hi,

I've been given a list of suppliers in two columns (A+B). Column A is the longer of the two lists and we need to identify which suppliers are listed in A but not in column B. I've input the following in column C which I think works but i'd like some reassurance that it is correct and i'd also be interested to know if there was an alternative/shorter way of achieving this?

Please Login or Register  to view this content.

Also - The IF/MATCH combo was returning an error when the supplier wasn't found hence why I added the IFERROR formula. Any idea why this is?

Thanks

Snook

I've run a quick test and it works fine.

Cheers dip11, any idea why I had to add the IFERROR formula to return the 'Not in list' text? I thought the IF/MATCH combo would have been sufficent?