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

Tags:

• ✭✭✭✭✭

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

Thanks & Regards

Khasim

SSPM Consultants

Email ID: [email protected]

Did I answer to your question or fix the problem? Please `help` the `Smartsheet Community` by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!

• ✭✭✭✭✭

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

Thanks & Regards

Khasim

SSPM Consultants

Email ID: [email protected]

Did I answer to your question or fix the problem? Please `help` the `Smartsheet Community` by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!