Hello,
How do I look up the Site name, Service level and Service area from the lookup table so the input result is the time.
Thanks
Tawnee
How do I look up the Site name, Service level and Service area from the lookup table so the input result is the time.
Thanks
Tawnee
Lookup Table | A | B | C | D | E | F | G | H |
1 | Site Name | Area | First | Priority | Standard | Two Day A.M. | Two Day | Express Saver |
2 | George | A1 | 8:00am | 10:30am | 3pm | 10:30am | 4:30pm | 4:30pm |
2 | Inland | A2 | 7:00am | 10:00am | 4pm | 10:30am | 4:30pm | 4:30pm |
Results | A | B | C | D |
1 | Site Name | Service Level | Service Area | Commitment Time Results |
2 | George | First | A6 | 8:00am (need formula here) |
2 | Inland | Standard | A2 | 4pm (need formula here) |