P
pboost1
Hello everybody. This is the formula that I am working with which is on
sheet 3 of a workbook. Homepage is on sheet 1.
"=IF(MONTH(D1)=MONTH(homepage1!H2),homepage!A2,IF(MONTH(D1)=MONTH(homepage1!H36),homepage1!A36,IF(MONTH(D1)=MONTH(homepage1!H64),homepage1!A64,IF(MONTH(D1)=MONTH(homepage1!H107),homepage1!A107,IF(MONTH(D1)=MONTH(homepage1!H144),homepage1!A144,IF(MONTH(D1)=MONTH(homepage1!H188),homepage1!A188,IF(MONTH(D1)=MONTH(homepage1!H433),homepage1!A433,703)))))))"
This works, but when the information on the homepage gets readjusted,
then this formula doesn't work as well. Is there a way to have the
cells be automated where if the information does get readjusted, the
formula will still work?
sheet 3 of a workbook. Homepage is on sheet 1.
"=IF(MONTH(D1)=MONTH(homepage1!H2),homepage!A2,IF(MONTH(D1)=MONTH(homepage1!H36),homepage1!A36,IF(MONTH(D1)=MONTH(homepage1!H64),homepage1!A64,IF(MONTH(D1)=MONTH(homepage1!H107),homepage1!A107,IF(MONTH(D1)=MONTH(homepage1!H144),homepage1!A144,IF(MONTH(D1)=MONTH(homepage1!H188),homepage1!A188,IF(MONTH(D1)=MONTH(homepage1!H433),homepage1!A433,703)))))))"
This works, but when the information on the homepage gets readjusted,
then this formula doesn't work as well. Is there a way to have the
cells be automated where if the information does get readjusted, the
formula will still work?