match and index question

[StuPri]

I have never really used match and index before and I believe these will be needed to solve my problem

I price list in one sheet and an invoice in another

In the invoice I get in info in 4 columns that I use to check against my price list - Country, zip code, weight and then price

The price list format can be changed to help solve this if needed but I need to know what changes to ask for

currently my price list has 2 columns of country and zip code and then weight band on the row of the table[TABLE="width: 500"]
<tbody>[TR]
[TD]Country[/TD]
[TD]zip code[/TD]
[TD]Weight <=250kg[/TD]
[TD]<=500kg[/TD]
[TD]<=1000kg[/TD]
[TD]<=1500kg[/TD]
[/TR]
[TR]
[TD]Austria[/TD]
[TD]9332[/TD]
[TD]£50[/TD]
[TD]£100[/TD]
[TD]£150[/TD]
[TD]£200[/TD]
[/TR]
[TR]
[TD]Austria[/TD]
[TD]9550[/TD]
[TD]£50[/TD]
[TD]£75[/TD]
[TD]£100[/TD]
[TD]£150[/TD]
[/TR]
</tbody>[/TABLE]

The invoice I get has the exact weight e.g 376kg so I need to also somehow round this up to match the weight category

can anyone help with this?

 

[mole999]

the CEILING Function > CEILING function - Office Support, could help if most of your steps are in a 500Kg bracket, maybe two IFs to sort up to 250 and then over 250