Formulas on work sheets

[Guest]

Target:
I have to creat a report that calculates freight charges to different
cities, based on weight. I would like to set-up a pricing sheet with all
destinations, that shows for example the rate to "Seattle" is 5.00 per kg,
the rate to "Chicago" is 3.00 per kg.

What I am trying to do is to create a formula that every time when I entere
"Seattle" as destination, it automatically calculates the freight charges
based on the 5.00 I entered on a separate worksheet.

Basically, a formula that gets a pre-defined numeric value simply by
entering a pre-defined destination.

I have no clue whether that is even possible, but I hope it is. Thanks for
any help.

Simon

 

[Guest]

Sounds like you are looking for VLOOKUP

http://www.contextures.com/xlFunctions02.html

 

[Guest]

Define a list and use the values for destinations. you will get corresponsing
values or you can also use a predefined table and then use a Vlookup
Function. Whichever suits your task and expertise level.