Formula for referencing a single range in another sheet

[Kram222]

I need my current formula to reference a specific range.

I have a schedule and i want my
1) from the data (utilities) sheet to go to the required week/sheet

2)find all the required tasks (eg: "vip*") for the said person
(each person has 3 columns: Task title, facetime, officetime)

it will need to search the task (column1) and add the time (column2) from the schedule

i have the formula that can do this [B]EXCEPT[B] for it to check the needed name on the data sheet and reference that with the name in row C and commence the calculations within the 3 columns under that name.

here is my ccalculation formula:

Please Login or Register  to view this content.

the next step that i got was:

Please Login or Register  to view this content.

But it isnt checking within different ranges
Should I have a feeling i should be Matching
maybe something like this?:

Please Login or Register  to view this content.

and if so, where should it be entered?
however im really stuck and just guessing now!

I'm Really Stumped! please [B]HELP![B]

The place where i want this formula is on my: Utilities sheet under the VIP column

here is my dummie workbook:Matching teacher to schedule range.xlsx

[Kram222]

Please someone...

[Kram222]

can someone please take a swing at this?

i know its tricky but please i need help with this!

[Kram222]

can someone please take a swing at this?

i know its tricky but please i need help with this!