Lookup Cross Sheet Reference

mgilkessmith

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!

Paul Newcome

You could use a COUNTIFS and say that IF the count is greater than zero, output "Match".

=IF(COUNTIFS({Sheet 1 SKU Column}, @cell = SKU@row)> 0, "Match")