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)
No comments: