Lookup function

J

Jeanke

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(N8>NOW();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?
 
J

John Mansfield

Jeanke,

I think you have semi-colons whare commas should be. Try:

=IF(N8>NOW(),VLOOKUP(A8,uurschema,3,FALSE),0)
 
K

Kassie

What do you mean with "past the present date"? Do you mean a date in the
future? If not, you should use "<" iso ">".

Also, is there a value in A8 that matches a record in uurschema, and if so,
is there a value in the relevant uurschema row's offset 3 column?
 
J

Jeanke

this doesn't seem to work. There is a value that matches a record in
uurschema and there is also a value in uurschema row's offset 3 column.

Think the problem lies in the first part. I have a column with dates. I
just want to show a value using the lookup function whenever the date in
column N is past the present date.

Any help is much appreciated
 
K

Kassie

Try =IF(NOW()<N8;VLOOKUP(A8;uurschema;3;FALSE);0), or swop the < with > if
that is what you want. Seems to work for me, while your sequence doesn't work
 
Top