[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: vlookup
The OpenFormula draft says: VLOOKUP Summary: Look for a matching value in the first column of the given table, and return the value of the indicated column. What does "the value of the indicated column" mean? Excel and Gnumeric are returning 0 if the cell in the indicated column is empty. OOo appears to return the empty string. Andreas -- "Liberty consists less in acting according to one's own pleasure, than in not being subject to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own." Rousseau Prof. Dr. Andreas J. Guelzow Dept. of Mathematical & Computing Sciences Concordia University College of Alberta
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]