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

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>
[TD="class: xl66"]

[TABLE="width: 500"] <tbody>[TR] [TD]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>

[/TD]

</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]

 

[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