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?
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?