Vlookup Multiple search criterias

Hi all,

I have this formula that does the following:

=IF($B$4="";"";VLOOKUP($B$4;Bookings!$B$10:$AD$942;4;0))


B4 = "a date"
Bookings!B10:AD942 = The matrix contains dates / names / etc.
4 = Returns the row 4 which is a "name"


How can i make this formula to search for a date (B4) and also include another search criteria like (E4) ( Doesnt matter if its a number or text )

So Vlookup meeting 2 criterias and returning the values based on the IF (B4)


Thanks