how does it differ to 2003?

in 2003 you'd do =vlookup([RangeContainingUniquieID1stSheet],[RangeContainingUniquieID2ndSheet],1,False)

then all those that return #N/A are the ones that are missing

Posted By: Ralf Scrampton, Feb 24, 15:58:59