cross refference formula that meets multiple criterias

Bobby1

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

Khasim

Hi @Bobby1

You want to create a formula in a such a way that should cover all below points. If So, then I can see result column where your mapping the same. Is it manual update?

• 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

Khasim

Hi @Bobby1

You want to create a formula in a such a way that should cover all below points. If So, then I can see result column where your mapping the same. Is it manual update?

• 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