Forum Discussion
Help w Drop Down Formula
Trying to set up a drop down menu in A2 that populates B2 with a value.
When the user chooses one of the drop-down options in cell A2, I want the value in the cell adjacent to their choice (either 6B, 7B, or 8B) to appear in cell B2. Can't I do that with a nested If statement?
There are innumerable options, here are three using your data:
=LOOKUP(A2,A6:B8)
=VLOOKUP(A2,A6:B8,2)
=XLOOKUP(A2,A6:A8,B6:B8)
You might also work with INDEX/MATCH or INDEX/XMATCH
Shane Devenshire
6 Replies
There are innumerable options, here are three using your data:
=LOOKUP(A2,A6:B8)
=VLOOKUP(A2,A6:B8,2)
=XLOOKUP(A2,A6:A8,B6:B8)
You might also work with INDEX/MATCH or INDEX/XMATCH
Shane Devenshire
Except LOOKUP() won't work, at least correctly, on unsorted names.
Actually, the first and third formulas require the data be sorted. If not the first formula needs to be =VLOOKUP(A2,A6:B8,2,0) or =VLOOKUP(A2,A6:B8,2,FALSE) .
