dependant validation lookups and multi validaton from single source

[mark-gabb]

yeah hi guys first post here

Im working on a difficult excel sheet using multiple drop downs and validations

Basicly I have my data sheet on sheet 1 and on sheet2 I have the following setup

A company
B service
C day
D time
E auto populate unit cost
So company is easy I just created a list for it to base off
Service I need to base of company as at the moment during creation im using 2 company but later there will be 9-10 and not all offer the same service, but using the offset method I get multiple copys of each service wheni create the list
C day is easy as it operates on a dependant list

Imd stumped of d for time as different companys use different times for each day
If any one can help me workout how I should be doing this it would be great

[dilipandey]

HI Mark,

see the defined name "company1" which I used in template in column B in the attached file:-
cares work out sheet.xlsx


Regards,
DILIPandey
<click on below * if this helps>

[ratcat]

G'day Mark and welcome to the forum,

Is this what your after, see the attachment.

[mark-gabb]

thats awesome, its getting alot closer to what im trying to do,
my only problem is that im trying to make it as idot proof as possible, so that if they pick say sgsc on a monday and personal care, they can only select times that are applicaple to that day so that they cant stuff it up

[ratcat]

G'day Mark

Which help workbook are you referring too ?