Can anyone please tell me what I'm doing wrong . I have a simple 2 colimn list consisting of dates then values my formaula looks like =VLOOKUP(J2,D2:H72,2,TRUE)
and I expect it to lookup the nearest date and return a value. Even when I enter an exact date that I know there is a match to I get the same result #N/A
I've tried formatting the dates differently but still no joy.
I tested the dates by taking date1-date2 and get a correct result so I'm unsure where the problem lies.
and I expect it to lookup the nearest date and return a value. Even when I enter an exact date that I know there is a match to I get the same result #N/A
I've tried formatting the dates differently but still no joy.
I tested the dates by taking date1-date2 and get a correct result so I'm unsure where the problem lies.