I am trying to create an INDEX MATCH function which needs both a key and calendar values to lookup a value in another worksheet. SO below is the data and in the sheet to have the formula, I need to know what the value is in the Lookup table for Set2 and Mar.
Can someone advise on how the INDEX MATCH function should be constructed ?
Lookup Table
Key Jan Feb Mar Apr May Jun
Set 1 5 10 15 20 25 30
Set 2 6 11 16 21 26 31
Set 3 8 13 18 23 28 33
Set 4 11 16 21 26 31 36
Set 5 16 21 26 31 36 41
Key Jan Feb Mar Apr May Jun
Set 1
Set 2 ?
Set 3
Set 4
Set 5
Can someone advise on how the INDEX MATCH function should be constructed ?
Lookup Table
Key Jan Feb Mar Apr May Jun
Set 1 5 10 15 20 25 30
Set 2 6 11 16 21 26 31
Set 3 8 13 18 23 28 33
Set 4 11 16 21 26 31 36
Set 5 16 21 26 31 36 41
Key Jan Feb Mar Apr May Jun
Set 1
Set 2 ?
Set 3
Set 4
Set 5