Nesting Statements with Data Validation

[beans1181]

Hello-
Can anyone help me with a nesting statement that I am trying to work into the Data Validation Source and I can't seem to get around the error.

I have 5 IF statements in Sheet1 that I am trying work into the Data Validation Source.

So my formula should be:
=IF($AM$16="South Atlantic",rw28SA,IF($AM$16="Florida",rw28FL,IF($AM$16="South East",rw28SE,IF($AM$16="South West",rw28SW,IF($AM$16="Gulf Coast",rw28GC)))))

I am only able to work 3 statements which are:
=IF($AM$16="South Atlantic",rw28SA,IF($AM$16="Florida",rw28FL,IF($AM$16="South East",rw28SE)))

My validatoin names are found in Sheet2:
rw28SA
rw28FL
rw28SE
rw28SW
rw28GC

Is there a way I can go about this?

Thanks.

 

[Joe4]

Do you even really need Data Validation at all?
Why not just have a formula return the value you want, instead of using Data Validation to limit it to one option depending on what is found in cell AM16?
The easiest way would be to create a two column lookup table, and use the VLOOKUP function.
See: MS Excel: VLOOKUP Function (WS)

 

[beans1181]

Hi Joe-
Thanks for the input but yes, the Data Validation is part of the format that was given to me to work with.

I was actually able to solve my problem. My formula did not include the "if false" value and AM16 was actively blank. That's why it was giving me an error.