https://bugs.freedesktop.org/show_bug.cgi?id=87208
Bug ID: 87208
Summary: VLOOKUP function returns NaN when copying formula
Product: LibreOffice
Version: 4.2.6.3 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 110700
--> https://bugs.freedesktop.org/attachment.cgi?id=110700&action=edit
Sample of VLOOKUP Nan issue
I have a VLOOKUP table in $F$2:$G$11 in the attached sheet. I have data in
cells A20:C27; I enter a VLOOKUP formula in A21:
=VLOOKUP(C21,$F$2:$G$11,2,0)
It looks up the correct value. If I copy the formula to cell A22, the
displayed value in A21 and A22 change to "NaN"
Changing the fourth parameter from 0 to 1 does not help.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
