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
Bookmarks