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.