Forum Discussion

Steve Aichele's avatar
Steve Aichele
Copper Contributor
Oct 15, 2018

Need Help with "It this, then" Formula

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.

BI & Data Analytics
Need Help

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Oct 15, 2018

    Hi Steve,

     

    To see a good example on IF and how to use it, please visit https://support.office.com/en-us/article/IF-function-69AED7C9-4E8A-4755-A9BC-AA8BBFF73BE2.

    But, in your case, I think that the most recommended way is to use one of the lookup functions such as https://support.office.com/en-us/article/VLOOKUP-function-0BBC8083-26FE-4963-8AB8-93A18AD188A1 as the below example.

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

     

    Please find the attached file

    Hope that helps