INDEX() MATCH() Issue

[LVExcel]

Can you please help with this formula, I have looked at it up and down and can't ID the problem.

From Sheet1 I'm looking in Sheet2 with my Costs and can not return the correct cost.

My formula is in Column C
=INDEX(Sheet2!A:GZ,MATCH(A2,Sheet2!$A:$A),MATCH(B2,Sheet2!$4:$4))
The only one that seems to return the correct amount is AU .023 lbs, however I would like it to return the next weigh , but could not find a Rounding function that would help.

Column A is my Weights
Row 4 contains my 2 digit Country codes

 

[SanjayGMusafir]

Two problems both in MATCH Function

Check this -

=INDEX(Sheet2!A:GZ,MATCH(A2,Sheet2!$A:$A,1),MATCH(B2,Sheet2!$4:$4,0))

You need to tell Match to look for Exact (0), Lesser (1) or Greater (-1) value than you are looking for - Change First Match accordingly.

Try it

 

[LVExcel]

Two problems both in MATCH Function

Check this -

=INDEX(Sheet2!A:GZ,MATCH(A2,Sheet2!$A:$A,1),MATCH(B2,Sheet2!$4:$4,0))

You need to tell Match to look for Exact (0), Lesser (1) or Greater (-1) value than you are looking for - Change First Match accordingly.

Try it

That did it , thank you so much, never thought that could be the issue.
I wish I could do (-1), but can not sort my data in descending order due to other formulas.

 

[SanjayGMusafir]

That did it , thank you so much, never thought that could be the issue.
I wish I could do (-1), but can not sort my data in descending order due to other formulas.

You can use that - from what I see from your sample data posted, it's kind of sorted for MATCH function to work properly.