Hi,
Need some help with a formula here please...
I have a list of food consumption postings, remarking the posting date and room number of the guest who consumed the food. Now I have another report with the arrival, departure and number of adults per room. I would like to link those two reports together by both matching the ROOM NUMBER as well check if the POSTING DATE is between the the arrival and departure date of the room. If yes, I would need the formula to return the total number of adults in the room.
So in short:
* Match both reports by room number AND see if posting date is between arrival / departure
* return the number of adults from Data 1 sheet to Data 2 sheet
I have attached a sample and would love to get some guidance on this
Thanks,
A2k
Lookup Sample.xlsx
Bookmarks