Hello

I'm trying to make a lookup function based on dates. i use this: =LOPSLAG($A4;'Master Geo'!A:AC;B$3)

The issue is that it gives the value from the wrong date - so if I lookup 20/12/1920 it gives me 19/12/1920 instead - why is that?

if I insert 0 or False it just says #I/T

Best regards