Friday, 1 August 2014

index match formula in excel

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)

0 comments:

Post a Comment