lookup value if it match a criteria.

[coolhit]

Hi,

Please can someone help with lookup.

As its very new thing for me to do lookup like this one.

I have attached file if you could assist me.

User enters Date in "Bookings DAY COMPILER" sheet cell F2 and press the buttton.

Macro looks up the date which user has entered and matches the date in "Booking IN CALENDAR" and bring over column B(time) and C(delivery ref) in "Bookings DAY COMPILER" in B5(Time) and C5(Delivery Ref).

Please can someone assist me.

Many Thanks in advance.