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
Bookmarks