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")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!