# Rates per city per KG

#### NunoS

##### New Member
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

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### etaf

##### Well-known Member
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

Last edited:

Replies
14
Views
526
Replies
2
Views
287
Replies
4
Views
154
Replies
0
Views
426
Replies
1
Views
365

1,191,165
Messages
5,985,036
Members
439,935
Latest member
Monty238

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back