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


"Rick Rothstein (MVP - VB)" wrote in
message ...
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