https://bugs.freedesktop.org/show_bug.cgi?id=78314
Priority: medium
Bug ID: 78314
Assignee: [email protected]
Summary: VLOOKUP() fails to find existing string
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 98519
--> https://bugs.freedesktop.org/attachment.cgi?id=98519&action=edit
VLOOKUP() fails to find existing string
When looking up a string "H.1", some modifications of basically the same
equation fails.
Original equation:
=IF($Aputila.$O$5="X",VLOOKUP($Aputila.$O$6,$Tavarat.$B$4:$H$104,$Tavarat.$C$107,0),"Else")
gives a result #N/A.
Modifications:
=VLOOKUP("H.1",$Tavarat.$B$4:$H$104,$Tavarat.$C$107,0) return "Okay"
=VLOOKUP("H.1",$Tavarat.$B$4:$H$104,2,0) return "Okay"
while modification
=VLOOKUP($Aputila.$O$6,$Tavarat.$B$4:$H$104,2,0) return #N/A
The content of $Aputila.$O$6 is ="H.1"
Expected return value for all above equations is "Okay".
Calc version: Version: 4.2.3.3 Build ID: 420m0(Build:3)
--
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
