ok so ive made a few changes sheet one represents the data i want to work with, im now using a seperate list to select company

so on the second sheet sheet i guess it has to be some kind of match formula so if a2:a100 = sgsc display b2:b100 that matches it, and so then one the 3rd one if a2:a100 and b2:200 match sgsc and personal care show days of week, that one isnt a huge deal
but times of day as we have two seperate companys that operate different times of day im struggling with
that and for b and d columb i cant work out either how to link both to seperate lists based on answer and how to remove the duplicates and only have one of each

as the services will be different as more companys are added
say 3rd company cgsc dont offer travel, so having a static seperate list for service wont work.....


please god help me

Attached Files

cares work out sheet.xlsx (22.8 KB, 10 views)