| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automate formula
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(MO NTH(D1)=MONTH(homepage1!H64),homepage1!A64,IF(MONT H(D1)=MONTH(homepage1!H107),homepage1!A107,IF(MONT H(D1)=MONTH(homepage1!H144),homepage1!A144,IF(MONT H(D1)=MONTH(homepage1!H188),homepage1!A188,IF(MONT H(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? -- pboost1 ------------------------------------------------------------------------ pboost1's Profile: http://www.excelforum.com/member.php...o&userid=11895 View this thread: http://www.excelforum.com/showthread...hreadid=517529 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
