Jessica Conrad
New Member
Hello.
I have 2 spreadsheets that I need to compare. I need a formula that looks for criteria 1 and criteria 2 on spreadsheet 1 and looks for the same combo on a second spreadsheet to let me know if it is duplicated.
Example- I have a customer PO that goes to multiple cities on 2 spreadsheets. I need to know not only if a matching PO is on the second spreadsheet, but if PO 1234 AND the city of Hanover is as well. So I have a bunch of formulas that can tell me if one of the criteria is on the second spreadsheet, but not both of them.
Thanks for your help!
I have 2 spreadsheets that I need to compare. I need a formula that looks for criteria 1 and criteria 2 on spreadsheet 1 and looks for the same combo on a second spreadsheet to let me know if it is duplicated.
Example- I have a customer PO that goes to multiple cities on 2 spreadsheets. I need to know not only if a matching PO is on the second spreadsheet, but if PO 1234 AND the city of Hanover is as well. So I have a bunch of formulas that can tell me if one of the criteria is on the second spreadsheet, but not both of them.
Thanks for your help!