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 terms
in the below (identifiable data removed) i am looking up from one sheet into a huge date vlookup sheet- my data is fine until i hit week 53 in 2020 and then all my dates seem to go off course -
for info a data point dated 27/7/22 is giving me a trading week of 32 when in reality this should be week 30- I am matching week dates off https://www.epochconverter.com/weeks/2022
Let m know how i can fix this or i can attach sheets in you can help
4 Replies
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?
cmckernan93 Are you using the ISOWEEKNUM function. That one returns the same values as the web site you refer to. Thus, no need to look them up.
