Hi
I have a booking appointments spreadsheet. This workbook schedules appointments from phone calls on a daily basis.

Worksheet 1 (Appointments), I have a drop down validation cell for dates giving dates until the year 2008 in cell F4 and one for Time 11:am thru to 19:00pm in 30 min increments in cell G4. There are 30 rows which is more than enough to take the daily appointments, because at the end of the day the sheet is cleared (Sent to Outlook)

Worksheet 2 (Appointment Diary), I have a table array named 'bookings with Col C
Giving the corresponding dates as in cell F4 Worksheet 1 993 rows, and Col D to T 11:00 to 19:00 in 30mins slots, 17 in total.
All the cells have a value of 'Free. As appointments are made the cells are populated with 'booked according to date and time.

Worksheet 1 named ‘Appointments
Appointment Date.............................................................Time
Drop down box containing dates................................Drop down box containing time 11:00 thru to 19:00

Worksheet named ‘Appointment Diary
Col C D E F G H I J K L M N O P Q R S T
Dates 11:00 11:30 12:00 12:30 13:00 13:30 14:00 14:30 15:00 15:30 16:00 16:30 17:00 17:30 18:00 18:30 19:00
21/05/05 Free Free Free Free Free Free Free Free Free Free Free Free Free Free Free Free Free
22/05/05 Free Free Free Free Free Free Free Free Free Free Free Free Free Free Free Free Free down to row 993

I need to book appointments but first check availability via worksheet 2 Appointment Diary, if free populate that cell with a CustomerID number

Any ideas, I have trawled the forum and tried various lookup's double lookup's
Bern