Hi All,

I'm having issues getting my head around this issue, I have a list of vendors in Column B of Sheet1. (circa 2000 vendors)

In Sheet2 I have a list containing the majority of those same vendors in cells A8:A1350, I need a formula (that I can use in cell A1370:Axxx) that will list the next vendor not already included in range A8:A1350.

In a few months I'll need to recreate the formula to exclude the vendors in the ranges A8:A1350 and A1370:Axxx

The formula below is about as far as I've managed and I can't see any examples out there.

=IFERROR(INDEX(Sheet1!$B$1:$B$2000, -COUNTIF(?? ,"")

Any assistance would be appreciated.

Thanks