Multiple Conditions with INDEX

[jmacritz]

I have a table on one sheet called BOOKINGS that has information for who booked a room, what room they booked, the date and what resources they need. I can look up and display every entry for a particular room easily enough but what I'd like to do is to display only the entries for that room within the next two weeks. An example of my table

Booked By Room Date Resources Tim Oak 9-may-19 Projector Tony Pine 7-may-19 Fold Out Mike Pine 15-may-19 Laptop Tim Elm 10-may-19 Sci Equip Lucy Elm 13-may-19 Projector Lucy Oak 14-may-19 Laptop Mike Willow 5-may1-9 Fold Out Sandra Pine 22-may-19 Projector Victoria Willow 28-may-19 Projector <tbody> </tbody> On a different sheet I'd like have the user input the room name (say in cell b2) and have it display Booked By, Date, Resources for anything matching the room name and within the next two weeks Any help would be appreciated <tbody> </tbody>

<tbody>
</tbody>

 

[Fluff]

The formula is fine.
Are you sure that your dates are real dates, rather than text?

 

[jmacritz]

I figured it out. Small error when I copied the code into the other cells. It works perfectly now.

Thanks again for all your help and walking me through it.

 

[Fluff]

Glad you figured it out & thanks for the feedback