Hi
I would create a lookup table on a separate sheet (e.g. called
'lookup') with the following format
A B C
1 Y N
2 small 1500 1000
3 corp. 2500 2000
4 ....
now use the following formula
=INDEX('lookup'!A1:C20,MATCH(C2,'lookup'!A1:A20,0) ,MATCH(A2,'lookup'!A1
:C1,0))
--
Regards
Frank Kabel
Frankfurt, Germany
"ringo tan" schrieb im Newsbeitrag
...
Hi,
I have a cell say "C2" containing a dropdown list for "small biz",
"corporate" and "enterprise". I have another cell say "C5" that
refers to
cell "C2".
a. If user select "small biz" in C2, C5 will show a price of say
$1000.
b. If user select "corporate" in C2, C5 will show a price of say
$2000.
c. If user select "enterprise" in C2, C5 will show a price of say
$3000.
Now, i need to add another condition to the above.
I have another cell A2 for user to enter a "Y" or leave as blank.
d. If user select "small biz" in C2 AND also enter a "Y" in A2, C5
will show
a price of say $1500.
e. If user select "corporate" in C2 AND also enter a "Y" in A2, C5
will show
a price of say $2500.
f. If user select "enterprise" in C2 AND also enter a "Y" in A2, C5
will
show a price of say $3500.
Can anyone give advice on how to write a function to incorporate all
6
conditions namely a,b,c,d,e,f in cell "C5", so that with or without
"Y" in A2
+ the result user selected in cell C2 in order to produce 6 different
prices
of $1000,$1500,$2000,$2500,$3000,$3500?
Thanks in advance.
Ringo
|