Apr 24 2023 01:13 PM
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
Apr 24 2023 01:20 PM
@anupambit1797
In C3:
=INDEX(I:I,MATCH($B3,$H:$H,0))
Fill to the right to D3, then fill down.