index match formula in excel

index match formula in excel:

If there is a different scenario in vlookup.

Primary key column is on right side vlookup are unable to fetch data. so here we use index match combined to get resultant data.

Syntax
=INDEX(D5:G10,MATCH(J6,H5:H10,0),1)