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:
(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.