I want to find the weight (A3 570) within the table (D1:K3), and return the
$/kg rate multipled by the weight, plus the Base. I'm struggling on using a
match/ index function, should I just be using a lookup function or both?

A B C D E F G H I
J K
1 1 250 251 500 501 1000
1001 3000
2 Base $/kg Base $/kg Base $/kg Base
$/kg
3 570 25 0.118 35 0.083 40 0.055 50
0.053
4
5