R
Rachelynn
Any ideas how to make this work?
I would like to have a scheduling chart that I can use with pivots an
filters.
A2 is the cell to lookup, the lookup chart contains a number which i
the number of months to add to a date. B2 is a starting date. What
have now is in D2, E2, F2, G2 the same formula as below but changed t
the cell to the left, and the column number of the lookup. This work
fine, but if the lookup formula returns zero, I would like the cell t
be blanked out without affecting the following cells formulas. Is ther
any way to do this? Right now I'm using a conditional format tha
changes the font to white so you don't see it, but of course it stil
shows up in pivots and filters. Help please, I'm stuck!
Thanks,
Rachel
=DATE(YEAR(c2),MONTH(c2)+VLOOKUP(c2,lookup,2,FALSE
),DAY(c2)
I would like to have a scheduling chart that I can use with pivots an
filters.
A2 is the cell to lookup, the lookup chart contains a number which i
the number of months to add to a date. B2 is a starting date. What
have now is in D2, E2, F2, G2 the same formula as below but changed t
the cell to the left, and the column number of the lookup. This work
fine, but if the lookup formula returns zero, I would like the cell t
be blanked out without affecting the following cells formulas. Is ther
any way to do this? Right now I'm using a conditional format tha
changes the font to white so you don't see it, but of course it stil
shows up in pivots and filters. Help please, I'm stuck!
Thanks,
Rachel
=DATE(YEAR(c2),MONTH(c2)+VLOOKUP(c2,lookup,2,FALSE
),DAY(c2)