Lookup function
Hello,
I want to have excel lookup something in a lookup table when the date
mentioned is past the present date. This is what I have :
=IF(N8NOW();VLOOKUP(A8;uurschema;3;FALSE);0)
Where N8 = column with the date.
However this doesn't work. It just says 0.
How do I get this to work?
|