Home / Excel / Study / index match formula in excel

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

You May Also Like

No comments:

Subscribe to: Post Comments ( Atom )
Powered by Blogger.