INDEX + MATCH_subband-size

[anupambit1797]

Dear Experts,

                      Could you please help in attached excel to use Index+Match to get the same result as Vlookup in Column "C" and "D".

Thanks & Regards

Anupam Shrivastava

[#2]

@anupambit1797 

In C3:

=INDEX(I:I,MATCH($B3,$H:$H,0))

Fill to the right to D3, then fill down.