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)
index match formula in excel index match formula in excel Reviewed by Unknown on 7:05:00 am Rating: 5

No comments:

Powered by Blogger.