Forum Discussion
Formulas and Functions
='January 2024'!G18 This is what I use in my Yearly Totals for getting the info off monthly worksheets. All the months work properly Except for (February, June) . When I build the formula:
='February 2024'!G18. What I get is: Invalid cell reference error. Same for June. I have used this method for years in my Budget Worksheets without any problem. I have deleted the page, rebuilt it and still get the same result for the two months.
3 Replies
rgw44 Are you sure that the sheet names are correctly spelled? Perhaps there are trailing spaces in the names.
Go to your Yearly sheet end in the cell for February, enter = and then point at the sheet tab for February and then at cell G18. This avoids naming errors in the formula. Repeat for June. Does this fix the problem?
Thank You for the reply. I have checked the spelling, I have re populated the tab, changed the spelling on both. They just seem frustrating. Using version 2021, have tried VLookup, X Lookup. Nothing seems to want to work. It is a simple formula. What am I missing
rgw44 don't really know what's missing. Can you upload the file or share a link to it that gives access on OneDrive or some similar file sharing site?
