Vlookup formula pulling data from wrong table

Glenn Baker

New Member
Joined
Oct 12, 2020
Messages
2
Office Version
  1. 2013
Platform
  1. 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!
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

C Moore

Well-known Member
Joined
Jan 17, 2014
Messages
540
Office Version
  1. 365
Platform
  1. Windows
When you look in the Name Manager, are the Refers To identical?
 

Glenn Baker

New Member
Joined
Oct 12, 2020
Messages
2
Office Version
  1. 2013
Platform
  1. Windows
No, that was one of the first things I checked. They each refer to their own sheet/table.
NAME MANAGER.PNG
 

Watch MrExcel Video

Forum statistics

Threads
1,114,098
Messages
5,545,951
Members
410,713
Latest member
TaremyLunsil
Top