that worked perfectly, thank you so much for the tip


while i have you could you also help with a further piece on what im looking up
my time validation is causing me trouble,
i would like it to return one time base for sgsc and the other results for bcsc, however im finding that if i ask it to just minimize the results to show for one company or another i am stuck with every copy of the time

more or less my plan is to make it as simple as possible for users, so that once they select company only services listed apear and so on

something along these lines but i doesnt work

=index(Sheet1!b2:b100(MATCH(A7, Sheet1!A2:A100,0)))

new update with suggested changes

Attached Files

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