multidependant validation and lookup

[mark-gabb]

hey guys



i know this has been covered before but im stuggling to work out how to get it to work for my circumstance

sheet1
a company
b service
c day
d time frame
e unit cost
f time spent
g total cost

im trying to work it out so that when you choose a company it lists the services of that company
then based on services you get a drop down for day, and so on till it auto fills unit cost


if anyone can give me some advice on this it would be great i have a sample im already working on but cant seem to get it quite right yet

edit: have done some more work on sheet to reflect 2nd company in first sheet and to sho difference in times of day for different companys