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?