Rates per city per KG

[NunoS]

Hello friends,

I am new here but i need your help for a excel sheet that i am making.

I have the City and the Weight in one sheet. In the other sheet, theres the cities, all weights and the costs.

In the first sheet, we can select the City and the weight. I want to show in that same sheet the rate.

Example :
1) I choose New York and 2 Kg, automatically will show 7.2USD.
2) I choose Washington and 10 Kg, automatically will show 10.1USD.

Something like that. Hope someone can help me.

I can try to send the Excel file to email

 

[etaf]

try

=INDEX(Sheet2!$C$1:$C$10,MATCH(A2&B2,INDEX(sheet2!$A$1:$A$10&sheet2!$B$1:$B$10,0),0))

assuming the lookup table is in sheet2
the cost is in column C
city and weight in A and B sheet2

then in Sheet1 A and B is the city and weight you want to find the cost for

dont email the spreadsheet , you can use dropbox or onedrive to load the sheet
there are other ways to show the cells here using jeanie