I am struggling to understand the data. What result numbers would be used in
this calculation if doing it on paper?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Qld Help.." <Qld wrote in message
...
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