PDA

View Full Version : [SOLVED] Expiry date



Tom Jones
09-02-2014, 06:12 AM
Hello,

I need a formula to add a predefined number of days to the date in column C, according to the name in column B. I can not use IF 's because the name in column A can sometimes be 25-30. Thanks

See the attached file.

Bob Phillips
09-02-2014, 07:14 AM
Try

=C4+VLOOKUP(B4,K4:L16,2,FALSE)

Tom Jones
09-02-2014, 07:59 AM
Thank you!