Defined Names within "IF" Functions

Book1.xlsxI am working on a spreadsheet for my boss, and I need some help.

Attached is an example workbook that I have been playing with, much like the one I need to make, just a whole lot simpler.

Cell B3 is a drop-down box with three choices (in this case seed). He wants to be able to pick a seed, then a separate drop-down box come down in C4 depending on his choice in B3. The function I have in is as follows:

=IF(B3=DATA!A1,CORN,IF(B3=DATA!A2,COTTON,IF(B3=DATA!A3,SOYBEAN)))

(The text in blue is the inserted defined name)

I have tried =IF(B3="CORN",CORN,IF(B3="COTTON",COTTON,IF(B3="SOYBEAN",SOYBEAN))) as well.

All I get is #VALUE!.

Is this even possible to get a drop-down menu from another drop-down menu? Each seed has its own.

You need to put that formula in Data Validation

On the Data Tab, click Data Validation
Select List
Enter that formula in the Source Box

I can't find an example formula. I see how it works, but what does the formula look like?

Thanks!

That didn't work. @Jonmo1

Originally Posted by emilydsmith

That didn't work. @Jonmo1

Sure it did, see Cell C4

emilydsmithEF.xlsx

Thank you so much! I don't know how I was doing it differently but thank you!

You're welcome.