web: vlookup in etherpad acts weird

lundi 28 septembre 2015

I have a small ethercalc table (see http://ift.tt/1ViuVGS ) and want to use vlookup, but I get a #REF! Error. I can't see why.

In short: the table looks like:

Date       ||Value
01-Sep 2015||1
   ...
28-Sep 2015||28

This is just an example to produce the error. What i did is:

=vlookup(today(), $A$2:$A$31, 3, 0)

Instead of getting the right number, I get a #REF! Error. But if I set the column value to 1:

=vlookup(today(), $A$2:$A$31, 3, 0)

I get the correct date value. What am I missing here? I would appreciate any suggestion.

thanks in advance Hannes

web