I have a formula that provides the last amount in a column where additional rows are constantly being added. The formula works perfectly, but now I want to put the same formula in another sheet in the workbook, so that it too would tell me the last amount on the first sheet. I can't figure out how to add the sheet name to this formula. The original formula is =IF(INDEX(F8:F900,COUNTA(F8:F900))>0,INDEX(F8:F900,COUNTA(F8:F900)),"")
So in Sheet2 I need the formula to be something like =IF(SHEET1!(INDEX(F8:F900,COUNTA(F8:F900))>0,INDEX(F8:F900,COUNTA(F8:F900)),"")) but so far I'm not getting anywhere and it's always the INDEX that it seems to not like. Am I tripping over parentheses? Should there be a comma after SHEET2!?
TIA
Using INDEX to get results from another sheet
-
- 2StarLounger
- Posts: 184
- Joined: 08 Feb 2010, 23:37
- Location: Howell, Michigan USA
-
- Administrator
- Posts: 78629
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Using INDEX to get results from another sheet
Try
=IF(INDEX(Sheet1!F8:F900,COUNTA(Sheet1!F8:F900))>0,INDEX(Sheet1!F8:F900,COUNTA(Sheet1!F8:F900)),"")
=IF(INDEX(Sheet1!F8:F900,COUNTA(Sheet1!F8:F900))>0,INDEX(Sheet1!F8:F900,COUNTA(Sheet1!F8:F900)),"")
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 184
- Joined: 08 Feb 2010, 23:37
- Location: Howell, Michigan USA
Re: Using INDEX to get results from another sheet
That's it exactly (of course)! Thanks Hans.HansV wrote:Try
=IF(INDEX(Sheet1!F8:F900,COUNTA(Sheet1!F8:F900))>0,INDEX(Sheet1!F8:F900,COUNTA(Sheet1!F8:F900)),"")
Sherry