Thread: Lookup function
View Single Post
  #1   Report Post  
Jeanke
 
Posts: n/a
Default 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?