Lookup values based on which days are selected

[arwhee]

This is hard to explain but I have set numbers, that need to be changed based on the days of the week that are selected.

This would be the given part of my sheet.

Example 1

Col A B C D E F J
Row 1 Sun Mon Tues Wed Thurs Fri Sat
Row 2 X X X
Row 3 4.5 3.5 3.75
Row 4
Col E
Row 5 Day 1 adjustment 1.0
Row 6 Day 2 adjustment 1.0
Row 7 Day 3 adjustment .5
Row 8 Day 4 adjustment 0
Row 9 Day 5 adjustment 0

I need to change the first 2 selected days by 1.0 and the 3rd by .5. I need a formula that will adjust any day selected. There could be up to 7 days selected with up to 5 different numbers that need to be adjusted. Row 4 would contain the new values.


Example 2

Col A B C D E F J
Row 1 Sun Mon Tues Wed Thurs Fri Sat
Row 2 X X X X
Row 3 2.5 2.5 3.75 3.25
Row 4
Col E
Row 5 Day 1 adjustment 1.25
Row 6 Day 2 adjustment 1.25
Row 7 Day 3 adjustment 1.25
Row 8 Day 4 adjustment 2.00
Row 9 Day 5 adjustment 0

 

[arwhee]

I hope this is posted with better formatting.
This is hard to explain but I have set numbers, that need to be changed based on the days of the week that are selected.

This would be the given part of my sheet.

Example 1

Col A B C D E F G
Row 1 Sun Mon Tues Wed Thurs Fri Sat
Row 2 X X X
Row 3 4.5 3.5 3.75
Row 4
Col E
Row 5 Day 1 adjustment 1.0
Row 6 Day 2 adjustment 1.0
Row 7 Day 3 adjustment .5
Row 8 Day 4 adjustment 0
Row 9 Day 5 adjustment 0

I need to change the first 2 selected days by 1.0 and the 3rd by .5. I need a formula that will adjust any day selected. There could be up to 7 days selected with up to 5 different numbers that need to be adjusted. Row 4 would contain the new values.


Example 2

Col A B C D E F G
Row 1 Sun Mon Tues Wed Thurs Fri Sat
Row 2 X X X X
Row 3 2.5 2.5 3.75 3.25
Row 4
Col E
Row 5 Day 1 adjustment 1.25
Row 6 Day 2 adjustment 1.25
Row 7 Day 3 adjustment 1.25
Row 8 Day 4 adjustment 2.00
Row 9 Day 5 adjustment 0

 

[arwhee]

Example 1 - Mon, Wed, Fri are selected, they have a value of 4.5, 3.5, and 3.75 but need adjusted by 1.0, 1.0, and .5 with the new value in Row 4.
Example 2 - Sun, Tues, Thurs, Sat are selected and have values of 2.5, 2.5, 3.75, and 3.25 and need adjusted by 1.25, 1.25, 1.25, and 2.00 with the new value in Row 4.