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

[The_Snook]

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?

=IFERROR(IF(MATCH(A1,$B$1:$B$90,0),"Matches","Not in list"),"Not in list")

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

[dip11]

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

[The_Snook]

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?