Forum Discussion
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 ...
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
