VLOOKUP Date Range Question and Help Please.

[hasnraz]

Hello Excel Experts.

I am facing some challenges in sorting an excel document, where there are occupancy percentage values by date (e.g. from Jan 1, 2018 to Yesterday) on one sheet and other sheet just have date ranges for a person's visit at our facility e.g. Mr. X visited from Sep. 23 to Oct. 28 (5 Days).

Now I need to sort out what was the occupancy percentage on each date of Mr. X visit? Hope this explains?

I have been using this formula but it only gives me a value for first date and not all the date for his visit: =VLOOKUP(G8,'Occ.'!B2:C295,2,0)

Please let me know.


Thank you for your help