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

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.

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

"Martin Zelones" wrote:
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.

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---