Forum Discussion
One cell multiple outcomes
I am new to using excel so I apologize for what may seem to be a obvious answer to a simple questions. I have at the moment a drop down to select values A-G in cell A2. I want A3 to produce a pr...
I'd create a lookup list. In the screenshot below, it is in H1:I7, but it could be anywhere, for example on another sheet.
You can then use H1:H7 as source for the data validation dropdown in A2, and use a VLOOKUP or XLOOKUP formula in A3.
Formula:
=IFERROR(VLOOKUP(A2,$H$1:$I$7,2,FALSE),"")