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