Index-Match Function Not Working all the time

Hope someone can help. I am losing my mind with this. I have attached the file for you to view. I have two drop down boxes which serve as the inputs to an Index function with 2 nested Match functions. The Index function works for the first 10 items of the "Largest Pipe Size" drop down, but does not work for any of the other. I have tried multiple versions of the forumla and formating the cells...nothing seems to work.

Here is my formula:
=INDEX($G$6:$P$44, MATCH($C$7,$H$6:$P$6,0), MATCH($C$6,$G$7:$G$44,0))

Any assistance would be Greatly Appreciated!!

Austin

Thanks shg. I got the formula to work by increasing the range of the match functions and following the correct row and column order in the INDEX function.

Thanks again for the help.

Here is the formula that ultimately worked

=INDEX($G$6:$P$44, MATCH($C$6,$G$6:$G$45,0), MATCH($C$7,$G$6:$Q$6,0))

Originally Posted by hoosierhunter

Thanks shg. I got the formula to work by increasing the range of the match functions and following the correct row and column order in the INDEX function.

Thanks again for the help.

Here is the formula that ultimately worked

=INDEX($G$6:$P$44, MATCH($C$6,$G$6:$G$45,0), MATCH($C$7,$G$6:$Q$6,0))

I think that should be something like:

=INDEX($H$7:$Q$44, MATCH($C$6,$G$7:$G$44,0), MATCH($C$7,$H$6:$Q$6,0))

in view of consistency...

Here is an alternative:
=SUMPRODUCT((G7:G44=C6)*(H7:P44)*(H6:P6=C7))

Hope it helped
Ola Sandström