What If Help required for nesting multiple what if's

[sweetmadness45]

Hello,

I am trying to run some "what if" statements using 4 possible words that may appear in one column, and 4 possible answers in another column. Each of the 4 words would trigger a different answer but the variables are the same.

For example. A1 may container the word, "Redel", "FPU", "NEW", or "RTW", and each of these words would have one of 4 results, either, Blank, no change, or the word "Burnaby" or "final pickup"

Is this possible to create?

I tried the following formula but it did not work;

=if(A1="redel","Burnaby,if(A1="new","",if(A1="rtw", ( I don't know the formula for no change, but this would be no change), if(A1="fpu",(no change))))

[MrShorty]

I would recommend a lookup table with a lookup function. VLOOKUP() seems to be the usual place to start learning about Excel's lookup functions: https://support.office.com/en-us/art...8-93a18ad188a1

[Sam Capricci]

=if(A1="redel","Burnaby,if(A1="new","",if(A1="rtw", ( I don't know the formula for no change, but this would be no change), if(A1="fpu",(no change))))

if that is your exact formula there are a couple problems with it.
=if(A1="redel","Burnaby",if(A1="new","",if(A1="rtw","no change",if(A1="fpu","final Pickup")))) or along those lines (provided you don't use the vlookup already suggested).