Applying a formula to a drop menu choice

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a validation field giving 5 options from which to choose in
ColB. In ColA a number field requires a manual entry, ColC is the result of
ColA x ColB (which should vary based on the choice made from the drop menu
choice in ColB).

Question is how to apply a differnet (hidden) formula to each of the
different text options in the drop down validation menu?

Many thanks in advance.
Regards ...Andrew
 
A more elaborate specification would help, but it looks like...

C2:

=CHOOSE(MATCH(B2,DataValidationList,1),Expression1,Expression2,Expression3,Expression4,Expression5)

ExpressionN is an calculation that involves A2 (user entry) which
depends on the choice from B2. DataValidationList is the list used to
data validate B2.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging/Combining workbook data 5
Matching data in two sheets 3
Place number into Cell Based on Match 4
VLOOKUP on multiple columns 1
Macro with line graph 2
Another related question to averaging previous values 1
Checking Column Status on closing excel - Macro Needed 2
Need formula dates 7

Back
Top