The values in lookup_vector ( in your case A:A) must be placed in ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP might not return the correct value. Uppercase and lowercase text are equivalent.
Last edited by Pecoflyer; 12-08-2011 at 10:36 AM.
Reason: Typo in col ref
|