#1
|
|||
|
|||
VLookup and year change from 2021 to 2022
Good evening! In my workbook everything worked as it should until the year changed from 2021 to 2022 and then all those cells got an "NA". The correct info is in the cells the VLookup is referring to but again all I get is "NA". I've been trying now for almost a month to figure this out and as you can tell haven't solved it. |
#2
|
|||
|
|||
You're asking for assistance with a formula to work on data and showing us neither.
If no exact match is found, #N/A is returned MS Excel: How to use the VLOOKUP Function (WS) |
#3
|
|||
|
|||
Update on info
Sorry about the lack of information. I hope this helps. If needed I can upload the file as well...
calendar reference.JPG change in year.JPG evaluated formula.JPG |
#4
|
|||
|
|||
Your named range 'Due_Production_Date_Data' only goes to row 192
|
#5
|
|||
|
|||
Either:
a) Define your table on sheet Calendar as Table, and refer to it using Table formula syntax; or b) Define the range 'Due_Production_Date_Data' as Dynamic Range, like: Due_Production_Date_Data = OFFSET(Calendar!$A$1,1,,COUNT(Calendar!$A:$A),5) |
#6
|
||||
|
||||
And, as OFFSET is a volatile function why not make your ranges Excel tables ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#7
|
|||
|
|||
Thank You!
I want to Thank everyone that has helped.
|
Tags |
vlookup, year change |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word field last month not working within year change | eduzs | Word VBA | 4 | 07-25-2019 04:31 PM |
How to search for a specific year from a table with year range? | Wii | Excel | 0 | 05-05-2015 12:40 PM |
How to calculate a rolling year-to-date percentage by quarter as the year progresses | sleake | Excel Programming | 2 | 04-23-2015 11:51 AM |
Does anyone know if you can keep a calendar template full o info but change the year? | dartist | Word | 3 | 02-12-2014 01:28 AM |
Creative Ways for a year-to-year comparison??? | ridonkulous5 | Excel | 1 | 03-23-2011 04:49 PM |