Forum Discussion
Formula to Autofill Value Based on Another Cell
I solved part of this but not the second part. I have these three columns on a document I am working on. I need a formula to do two things: If Column I lists a frequency (Annual, Biannual, Triannua...
For example:
=IF(I2="TBD", "TBD", IFERROR(EDATE(J2,LOOKUP(I2,{"Annual","Biannual","Triannual"},{12,24,36})),""))
Perfect, thank you!