cross refference formula that meets multiple criterias
the problem i have is that there are 2 spreadsheets used by 2 teams, but both should have the same info. in the screenshot, i displayed the different scenarios. I can keep it simple and have returned a MATCH or NO MATCH. The goal is to have the formula return with a value that indicates where the discrepancy lies.
if sheet B cell is blank but sheet A is not. return sheet B- this way the team knows where to focus their attention
If sheet A is blank but sheet B is not, return the sheet A-this way the team knows where to focus their attention
if both Sheet A & Sheet B is not blank but do not match, return No Match.
If Sheet A & Sheet B has a match, return Match
Help Article Resources
Check out the Formula Handbook template!