more condition

[RKS]

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

 

[Rick Rothstein \(MVP - VB\)]

Put this formula in D50...

=TODAY()+LOOKUP(C50,A1:A3,B1:B3)

Rick

 

[Rick Rothstein \(MVP - VB\)]

I just re-read your post and see you said you have up to 40 data rows. Just
change the ranges from 3 to 40. Here is the formula again, modified for 40
data rows, and I added code to neaten up the display if there is no
selection in C50...

=IF(C50="","",TODAY()+LOOKUP(C50,A1:A40,B1:B40))

Rick