J
Jodie
Hi,
I need help to write a formula that will display all results for two sets of
criteria split across two worksheets.
Where Worksheet 1 displays
Column A
Therapist Name,
Column F-L
Days of the week they will work
Column M-T
Treatments they will perform
Worksheet 2 displays
Column F
Day of a party booking (in the form of a day of the week)
Column I-M
treatments used at the party.
I need a formula to give me all matching Therapist names (from Worksheet 1)
who will work on the day of the week of the party booking (from Worksheet 2),
who will perform the treatments that will be used at the party. The results
are to be displayed on a third worksheet in the form of
Column N
Available Therapist 1
Column O
Available Therapist 2
Column P
Available Therapist 3
and so on
Thanks for any help
I need help to write a formula that will display all results for two sets of
criteria split across two worksheets.
Where Worksheet 1 displays
Column A
Therapist Name,
Column F-L
Days of the week they will work
Column M-T
Treatments they will perform
Worksheet 2 displays
Column F
Day of a party booking (in the form of a day of the week)
Column I-M
treatments used at the party.
I need a formula to give me all matching Therapist names (from Worksheet 1)
who will work on the day of the week of the party booking (from Worksheet 2),
who will perform the treatments that will be used at the party. The results
are to be displayed on a third worksheet in the form of
Column N
Available Therapist 1
Column O
Available Therapist 2
Column P
Available Therapist 3
and so on
Thanks for any help