index match based on multiple criterias

Originally Posted by scottylad2

maybe 14?
=INDEX($D$5:$J$16,MATCH(C20,C5:C16,0),MATCH(E20,D4:J4,0))

this happen to do the trick! thx u so much!

NBVC, i appreciate the prompt response, you guys are the best

cheers