Lookup Cross Sheet Reference

I am having difficulty with writing a formula that will help me with cross-referencing two sheets for an inventory process.

Sheet1 has numbers from a previous inventory date and Sheet2 has numbers from a current inventory date. The SKU in the column labeled Column1 in Sheet1 could also be in Sheet2. I have created the column called Match in Sheet2 to enter the formula and to have the value "match" populate. The formula would need to index all of the SKU for Sheet1 Column1 and compare it with the Sheet2 Column1 cell of the row the formula has been input. If there is a match then the value "match" would populate in the Match cell.

I hope that makes sense.

I have tried a variety of formulas. Need some assistance please.

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!