index and match formulas

Attached is a spreadsheet I am working on. The cells I am having difficulty with are I5 and I6. Cell I5 should be pulling a value from the 2nd tab based on C4 and C5 AND C6. Or at least that is my intent. However when I change C6 to 6 I get an N/A. When it is 5 based on 15,000 it enters $2,353.73 but according to my table it should be $2,710.23 I am having the same issue with I6. Based on 15,000 it should enter $190. Where did I go wrong. Any help? Thanks in advance.

You ranges in the MATCH() functions for column extract, start 1 cell too far.. it should match where you indexed from...

so

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

as for the #N/A error, it is because you have a blank in column A where the 6 is in column B... you can copy down the values in column A so you have no blanks, or if you only have the 2 rows for each Sample#, then you can adjust the INDEX() function to offset by one row, when c6 = 6.

If that is the case, then replace formula with:

Please Login or Register  to view this content.