Forum Discussion
Help - Lookup based on a week ending date
Hello, I am having issues getting a table to pull the right dates - i have a source file that lookups up from a vlookup table but the week numbers don't actually match the trading weeks in real t...
i am getting an error for week 53 as i am looking up a concatenate value for cells I123 which errors off the VLOOKUP as rightly the year won't match the date
i.e. week 53-2020 will have dates in 1-3rd Jan 2021
how do i fix that to fix my trading week rank ( for info this is just a rank of when trading began adding +1 every time a trading week moves forward.
cmckernan93 Sorry, don't understand what you mean. Can you show the formula in I123 and what's isn the cell(s) it refers to?