Hi!

It's not real clear what you want.

Can you rephrase your explanation?

About all I got out of your post is that Monday appointments have a
different time range than the other days of the week!

How does that relate to a drop down?

Biff

"Tuttamay77" wrote
in message ...

Any ideas on how I can use a formula and two different ranges of data
for lookup lists in the Data Validation function?

Here is the issue. The form I created is a basically a schedule with
lots of data validation lists. The most recent problem is that the
validation list needs to be customized for appointments made on a
Monday. Monday appointment times begin at 9:00 AM - 5:00 PM else
appointments made Tuesday - Friday, the start time is 7:00 or 7:30 AM -
5:00 PM. The appointment times consist of 30 minute blocks.

I am trying to standardize the data to keep it simple for the users. Is
this possible? Thanks in advance.


--
Tuttamay77
------------------------------------------------------------------------
Tuttamay77's Profile:
http://www.excelforum.com/member.php...o&userid=33047
View this thread: http://www.excelforum.com/showthread...hreadid=528681