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?

Jeanke,

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

=IF(N8NOW(),VLOOKUP(A8,uurschema,3,FALSE),0)

----
Regards,
John Mansfield
http://www.pdbook.com


"Jeanke" wrote:

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?

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?

"Jeanke" wrote:

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?

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

"Kassie" wrote:

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?

"Jeanke" wrote:

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?

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

"Jeanke" wrote:

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?