Need Help with "It this, then" Formula

Question

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.

steve aichele · Answer

Thank you&nbsp;Haytham.&nbsp;The Lookup function is exactly what I needed.

haytham amairah · Answer

Hi Steve,&nbsp;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)&nbsp;Please find the attached fileHope that helps

Forum Discussion

Need Help with "It this, then" Formula

Share

Resources