Hi. Please help. I am using a vlookup. =VLOOKUP(B4,'data1'!$G$1:$AN$10000,4,FALSE)
B4 is a Sum which adds a date a time together.
=SUM($A$1+Lists!D1)
The aim is to look up data by half hourly interval. It works on 9 instances but i get #N/A on all other instances.
Please help this is driving me crazy.