Excel Drop down menu choice changes another cell.

December 8, 2012 at 08:09:27
Specs: Windows 7
Cause a drop down menu in Excel to change another Cell.
For example if Cell A1 = "AAA" then Cell B2 = 10 but if Cell A1 = "BBB" then Cell B2 = 20?

See More: Excel Drop down menu choice changes another cell.

Report •


#1
December 8, 2012 at 10:45:24
In cell B2 enter the formula

=IF(A1="AAA",10,IF(A1="BBB",20,""))

there are many ways you could do this but you'd need to be more specific about how many different conditions there are and what the results of each condition are.


Report •

#2
December 8, 2012 at 12:53:16
If you have a relatively large number of conditions to deal with, an IF function can be cumbersome.

Another option is to use VLOOKUP. With VLOOKUP you can build a table of choices that is essentially unlimited. A table of data might also be easier to change than a IF function, especially if the IF function is long and complicated.

As AlteK mentioned, there are lots of options, but we'd need more details to offer any more suggestions.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question