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

Country	zip code	Weight <=250kg	<=500kg	<=1000kg	<=1500kg
Austria	9332	£50	£100	£150	£200
Austria	9550	£50	£75	£100	£150

<tbody>
</tbody>

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