Index Match only working part of the time

I am having issues with row 2 and beyond when using an Index Match function.

=INDEX($F$2:$F$21,MATCH(J$4,$A$2:$A$21,0),MATCH($H5,$B$2:$B$21,0),MATCH($I5,$C$2:$C$21,0))

It works great for the first row. I have done the CNTRL Shift and Enter. However, when it goes to the second row and beyond, it results in a #REF! in the output table. If anyone has any ideas or a better way of doing this, please let me know.

Jeff

try =SUMPRODUCT(($A$2:$A$21=J$4)*($B$2:$B$21=$H5)*($C$2:$C$21=$I5)*$F$2:$F$21)

Thanks, Sandy! That works.

Jeff

You are welcome

If that takes care of your original question, & to say Thanks, please

1. click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
   then
2. select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.

If you did it already - ignore it.
Thank you.