Need Help with "It this, then" Formula

[Steve Aichele]

Hi all. I've researched "if this then" formulas but haven't found what I'm looking for.

Please tell me how to set up this simple version of of an "If" formula. 

Situation Overview: I have an Excel work order form where the user enters the "ship-to" location as Text in one field, and a Freight amount ($s) in another. 

Goal: Adding a location in the Ship-To" Field will automatically populate the Fright field with the correct rate. 

Thanks for the help.

[#2]

Hi Steve,

To see a good example on IF and how to use it, please visit this support page.

But, in your case, I think that the most recommended way is to use one of the lookup functions such as VLOOKUP as the below example.

=VLOOKUP(A4,$F$4:$G$11,2,0)

Please find the attached file

Hope that helps

[#3]

Thank you Haytham.

The Lookup function is exactly what I needed.