Need help with Multiple Criteria Search in Index Match or Vlookup

Hello All,

I am always thankful of the forum for always being a problem solver whenever I stuck.
I need a quick help on a formula of Index+Match / VLookup with multiple criteria (rows or column side).
Please help me on this I have attached the file mentioning what criteria we need to look and find the result (yellow highlighted) in the array list.

Thanks in advance to the problem solver.


Regards
Santosh

Thanks Sir, but I could not get your this point "amd remove #DIV0 errors in column G" as I am facing the same error.

Originally Posted by HansDouwe

Please try in L9 and copy to O9 and R9:

=INDEX($D$4:$D$99,MATCH(L4&L5&L6,$A$4:$A$99&$B$4:$B$99&$C$4:$C$99,0),MATCH(K7,$D$2:$I$2,0))

Thank you so much Sir for solving I wish I could learn more from you and make my logic more clear like you.