I have three spreadsheets, I need to search spreadsheet 1 for criteria specified in spreadsheet 2.

Once that has finished, I need to search based up the same field but which does not have the same values as the result of criteria 1.

Any help appreciated.

I have tried VLOOKUP, INDEX, MATCH and various combinations. Thanks.

douglas boyce