How do i use a combo box or drop down list to preform a calculatio

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

Guest

I want to use a drop down list or combo box to preform a calculation in a
worksheet. IS this possible or can use suggest another way of doing
calulations using a numbers that change.
 
Martin Zelones said:
I want to use a drop down list or combo box to preform a calculation in a
worksheet. IS this possible or can use suggest another way of doing
calulations using a numbers that change.
Click to expand...

Assume you have a DV* droplist in A1 which allows a selection of either: 1,
2, 3

Then you could just point at A1 in your formula, for example in say, C1:
=IF(A1="","",VLOOKUP(A1,{1,"A";2,"B";3,"c"},2,0))

C1 will evaluate based on the selected value in A1. If "1" is selected in
A1, C1 returns "A", "2" returns "B" and so on. If the selection in A1 is
cleared (with the Delete key), C1 will appear "blank".

*Similarly if you have a forms combo box with the cell link as A1, which
drops the values: 1, 2, 3 into A1 based on the selection made

---
 

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

Using Drop Down List or Combo Box 9
Drop Down with dynamic named range offsheet source list 14
how do you use formulas in a drop down box 1
controlling worksheets using combo-box 1
drop down box code 2
Locking combo box into a cell? 1
Using a combo box for more than one group of cells 1
Formatted cell column in drop down list 1

Back
Top