Glenn Baker
New Member
- Joined
- Oct 12, 2020
- Messages
- 2
- Office Version
- 2013
- Platform
- Windows
Hi,
I have a vlookup formula that I recycle and update the lookup reference on as the fiscal year changes: =IFERROR(VLOOKUP($A24,FEES_FY21,$H$2+1,0),0). I have multiple sheets in the workbook, and for some reason on some of the sheets, even though the reference has been changed to FY21, it is still pulling the data from the FY20 table. I've deleted both lookup references and re-did them, but that didn't help. FY21 is on a separate sheet from FY20, although in creating the FY21 sheet I copied the FY20 sheet, renamed it and deleted the FY20 data and replaced with FY21 data and created the new lookup reference. The sheets that I use the formula on have the months of the year repeating over for each FY, and I've got data pulling in for FY21 months that haven't passed yet with the same numbers for the same month in FY20, which is how I know it's pulling from the wrong table. I just created this workbook starting in FY20, so this is the first year of recycling the formula. The $H$2 in the formula corresponds to a particular month, and changes in the formula for each consecutive month.
Thanks for helping with this!
I have a vlookup formula that I recycle and update the lookup reference on as the fiscal year changes: =IFERROR(VLOOKUP($A24,FEES_FY21,$H$2+1,0),0). I have multiple sheets in the workbook, and for some reason on some of the sheets, even though the reference has been changed to FY21, it is still pulling the data from the FY20 table. I've deleted both lookup references and re-did them, but that didn't help. FY21 is on a separate sheet from FY20, although in creating the FY21 sheet I copied the FY20 sheet, renamed it and deleted the FY20 data and replaced with FY21 data and created the new lookup reference. The sheets that I use the formula on have the months of the year repeating over for each FY, and I've got data pulling in for FY21 months that haven't passed yet with the same numbers for the same month in FY20, which is how I know it's pulling from the wrong table. I just created this workbook starting in FY20, so this is the first year of recycling the formula. The $H$2 in the formula corresponds to a particular month, and changes in the formula for each consecutive month.
Thanks for helping with this!