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!
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

C Moore

Well-known Member
Joined
Jan 17, 2014
Messages
579
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
 

Forum statistics

Threads
1,141,022
Messages
5,703,791
Members
421,316
Latest member
Cyril Beki

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top