Fill Formula Not Adjusting Down the Column
I have a spreadsheet that has a summary sheet and multiple tabs. I have the
following formula in one of my summary sheet columns: =IF('1300'!$F$9=" "," ",'1300'!$F$9) -where 1300 is the name of one of the tabs and F9 within each tab is the piece of information I want pulled into the summary tab. The formula works correctly when I manually type it into any row with any tab # within it, so I think the formula itself is ok. However, it's not letting me drag the formula through the column and autofilling by changing 1300 to 1301, 1302, etc(representing pulling information off each consecutive tab). I already check that my calculation option is set to automatic and I've F9'd about 10 times now. Any other suggestions? |
Fill Formula Not Adjusting Down the Column
Try:
=IF(INDIRECT("'" & (ROW()-1+1300) &"'!$F$9")=" "," ",INDIRECT("'" & (ROW()-1+1300) &"'!$F$9")) Adjust to your starting row. HTH "lost in excel" wrote: I have a spreadsheet that has a summary sheet and multiple tabs. I have the following formula in one of my summary sheet columns: =IF('1300'!$F$9=" "," ",'1300'!$F$9) -where 1300 is the name of one of the tabs and F9 within each tab is the piece of information I want pulled into the summary tab. The formula works correctly when I manually type it into any row with any tab # within it, so I think the formula itself is ok. However, it's not letting me drag the formula through the column and autofilling by changing 1300 to 1301, 1302, etc(representing pulling information off each consecutive tab). I already check that my calculation option is set to automatic and I've F9'd about 10 times now. Any other suggestions? |
All times are GMT +1. The time now is 11:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com