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.
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.
Try
=C4+VLOOKUP(B4,K4:L16,2,FALSE)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thank you!