more condition
Put this formula in D50...
=TODAY()+LOOKUP(C50,A1:A3,B1:B3)
Rick
"RKS" wrote in message
...
a b c d
1 aa 5
2 bb 6
3 cc 7
.
50 aa today date+6 day
I can create validation list in C50 cell, which data comes from a1,a2 and
a3. i have like 40 data list which we use in C50. Now I want if I select
in
C50 like bb then D50 is today date+6 days display. Please help me its very
urgent. and tell me what function i can use and how. Please give example
also.
Thanks
RKS
|