Hello
I am hoping someone can offer advice on the best way to approach a lookup issue. Is there a lookup that would work?

Tab 1 I have inputs
Client, Order, Due Date, WeekID


Tab 2 I have a schedule
Client Week 1 Week 2 Week 3 Week 4 Week 5 Week 6


What I would like is to populate tab 2 with the Order Code from tab 1 in the appropriate Week ID column

Tab 1 Input
Client, Order, Due Date, WeekID
ABC Co YUM 2021-01-02 1
XYZ Co NUM 2021-02-05 6


Tab 2 Schedule
Client Week 1 Week 2 Week 3 Week 4 Week 5 Week 6
ABC Co YUM
XYZ Co NUM


Any advice welcome!

Thank you in advance for your help!

CDC