Booking Tracker

JoyceZ

New Member
Joined
Aug 10, 2019
Messages
1
Hi Everyone,

I am trying to create a booking tracker, for example if I input start and end date per guest/room, this days will be highlighted on calendar. One room can have different guest on different dates range.
I was using if(and(vlookup, but only able to have first guest info on the calendar, how to have 2nd guest info (different dates) mark on the calendar as well.
Anybody knows?
Many Thanks!
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,108,951
Messages
5,525,842
Members
409,666
Latest member
aquabit

This Week's Hot Topics

Top