Matching values from different datasets
Having difficulty trying to match 2 distinct values from one sheet to another.
We have one dataset that tracks submissions on a daily basis from multiple locations. I been trying to find a way to match 2 distinct values from one sheet to cross reference the master sheet to verify if a form submission was conducted from the location on a specific day.
The location submission picture showcases which location has filed a report for what day.
The location tracking picture showcases that location for the previous 3 days.
I been trying to use vlookup along with index/match function to get this to work but doesn't seem to be working.
From the location tracking, I'm trying to verify if the location has submitted a form for the dates listed above, and if so would like to indicate "Yes" it has been submitted, and "No" that there isn't a record for that specific date.
I been trying to lookup the location, and the date and match it to the master data set but it doesn't seem to be working.
Comments
-
Try something like this...
=IF(COUNTIFS({Master Sheet Location Column}, $[Airport Master List:]@row, {Master Sheet Date Column}, [Previous Day:]$1) > 0, "Yes", "No")
.
If you put that in the cell of [Previous Day:]2 (top left corner of your table data), then you can dragfill over and down to auto-update the formula with the correct cell references. Just be sure to leave the $ symbols where they are as they lock in row or column refrences as needed.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!