Populate cell based on drop down menu selection

Where does your dropdown data come from? A range of cells? A comma-delimited list? A named range? If the data is listed in some cells, do you have corresponding SKUs to go with them?

If your data is nowhere on the worksheet to reference, try either of these:

=CHOOSE(MATCH(B1,{"Orange";"Black";"Blue";"Yellow";"White";"Red";"Green";"Purple"},),"1234OR","1234BK","1234BL","1234YL","1234WH","1234RE","1234GR","1234PR")

or

=INDEX({"1234OR","1234BK","1234BL","1234YL","1234WH","1234RE","1234GR","1234PR"},MATCH(B1,{"Orange","Black","Blue","Yellow","White","Red","Green","Purple"},))


Simply edit/add/remove colors and SKUs as needed. (Note the slight differences in syntax between the 2 formulas. Most notably, semi-colons vs. commas.)


If your data exists somewhere on the worksheet, a VLOOKUP will be your go-to function.