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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!