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.
