Lookup but Return Range field should be based on Criteria

Hello. I need help on lookup formula. The return range is not based on a fixed source.

E,g, if my criteria is 28-Jan, the return range will be on column B of Lookup Table.
If my criteria 6-Feb, the return range is column D of Lookup Table.

Lookup Table 28-Jan 30-Jan 6-Feb 10-Mar
6-Jan 34,712 15,546 18,521 34,712
13-Jan 27,342 15,092 16,798 27,342
20-Jan 25,411 15,319 16,244 25,411
27-Jan 19,876 15,206 16,930 19,876

Criteria 6-Jan 13-Jan 20-Jan 27-Jan
28-Jan 34,712 27,342 25,411 19,876
30-Jan 15,546 15,092 15,319 15,206
6-Feb 18,521 16,798 16,244 16,930
10-Mar 34,712 27,342 25,411 19,876

Hi Ali. Thanks your formula works. Can you also do a same but Criteria is based on column instead?

Yes, this formula works. Thank you Glenn.