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!
Answers
-
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")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 75 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!