Thread: more condition
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_159_] Rick Rothstein \(MVP - VB\)[_159_] is offline
external usenet poster
 
Posts: 1
Default 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