I'm getting a #NAME? error and I just cant figure out why!! Deadline upcoming :(

[bigdan]

So I've got a ****load of work to do this weekend for Monday's deadline and I'm now getting this error and I just cant figure out why.

So to start with I'm pulling a bunch of data from our system, called BPC. F2025 is already loaded in the system, I'm now trying to get F2026's data.
The tab which has the info for F25 is called - F25_NextY2_Monthly_FcstBPC.
I've made another tab for F26 called F26_NextY3_Monthly_FcstBPC test

Both of these tabs look exactly the same. The contents within are 2% different but for all intents and purposes they're the same. So I would expect all vlookups on these tabs to function the same as well.

Now I've got a bunch of tabs that will pull information from here. The one I'm in now is called H8085. This has been able to pull the information from F25 just fine. The formula for Jan 2025 is: =VLOOKUP($B7,F25_NextY2_Monthly_FcstBPC!$A$14:$BD$4002,CJ$4,FALSE).

So I tried a formula that's almost exactly the same, for the same row, for Jan 2026: =VLOOKUP($B7,F26_NextY3_Monthly_FcstBPC test!$A$14:$BD$4002,CZ$4,FALSE)
But that's giving me a #NAME? error.

Please help!!

 

[Alex Blakenburg]

What is the sheet name that the formula with the error is meant to be accessing ?
If it is not meant to have a space before test then remove it.
If it meant to have a space you need to enclose it in single quotes.

eg with single quotes added it will look like this:

=VLOOKUP($B7, 'F26_NextY3_Monthly_FcstBPC test'!$A$14:$BD$4002, CZ$4, FALSE)

 

[bigdan]

What is the sheet name that the formula with the error is meant to be accessing ?
If it is not meant to have a space before test then remove it.
If it meant to have a space you need to enclose it in single quotes.

eg with single quotes added it will look like this:

=VLOOKUP($B7, 'F26_NextY3_Monthly_FcstBPC test'!$A$14:$BD$4002, CZ$4, FALSE)

Wow, fixed!! Thanks very much. At first I was thinking perhaps the length of the tab is the problem. But so now you're saying its the space, which also makes sense.

Thanks a lot!

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help. Hope you are on track to make your deadline.