Forum Discussion
Lookup Formula
Hi,
Apologies I know there is lots of videos online but I can't get my head around this.
I am looking I think for a look up function for generation (column G) for the date and time exactly 2 years after consumption (column J) from column D. There are dates in column D missing hence the need for the look up to get the values on the same row as the corresponding date and time 2 years later. Hope this makes sense, any help is much appreciated. Cheers.
I think using the DateAdd function (with an interval argument of "yyyy" and a number argument of 2) will help you more than a lookup.
