Can I use VLookUp if what I am looking up is a range of dates?
I need to cross check an entry in my smartsheet with a range of dates against another sheet. I am able to do a Vlookup for start date (first pic below) but am stumped on how I can get it to look across the range of dates I need (start date to last date). I think I need to use another formula but am unsure on how to express a date range in a find type formula. Not sure if this is making any sense. I added a pic for clarity. So here I am looking for to return an Error if FOB value is 3 or more for the dates 6-Apr-2021 until 9-Apr-2021. On the sheet it is referencing, all dates are in their own row in a date column seen in 2nd pic. Is it possible to do what I am trying to do?
Help Article Resources
Check out the Formula Handbook template!