INDEX + MATCH_subband-size

Question

Dear Experts,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Could you please help in attached excel to use Index+Match to get the same result as Vlookup in Column "C" and "D".&nbsp;Thanks &amp; RegardsAnupam Shrivastava

hansvogelaar · Answer

anupambit1797&nbsp;
In C3:
=INDEX(I:I,MATCH($B3,$H:$H,0))
Fill to the right to D3, then fill down.

Forum Discussion

INDEX + MATCH_subband-size

Share

Resources