Been trying to figure out this formula but unable to due to the Year to week Lookup criteria . Any suggestions pls
Go to Solution.
YEARVALUE function is automatically retrieving year value from the source. It doesn't require (or even allow) LOOKUP function to be used with it.
Thank you. It worked.