Bug 78314 - VLOOKUP() fails to find existing string
Summary: VLOOKUP() fails to find existing string
Status: RESOLVED DUPLICATE of bug 77990
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.3.3 release
Hardware: x86-64 (AMD64) All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-05 21:54 UTC by Teraslilja
Modified: 2014-05-08 05:43 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
VLOOKUP() fails to find existing string (18.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-05-05 21:54 UTC, Teraslilja 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Teraslilja 2014-05-05 21:54:50 UTC 
Created attachment 98519 [details]
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)
Comment 1 Jacques Guilleron 2014-05-07 15:43:51 UTC 
Hello  Teraslilja,

I reproduce this behaviour with LO 4.2.4.1, LO 4.3.0.0.alpha1+
Build ID: 0b03f7ed575838f90e6b1ebec3538a3a214f81fb
TinderBox: Win-x86@39, Branch:master, Time: 2014-04-30_01:30:46
& Windows 7 Home Premium.

Works with LO 3.6.6.2 and LO 4.1.6.2.

Regards,

Jacques
Comment 2 Kohei Yoshida 2014-05-07 17:52:10 UTC 
Likely fixed by Bug 77990.
Comment 3 Jacques Guilleron 2014-05-08 05:43:41 UTC 
Works with LO 4.3.0.0.alpha1+
Build ID: 657004ae5c9f4a07b2cdafbb21bc8657842d4d74
TinderBox: Win-x86@39, Branch:master, Time: 2014-05-08_00:35:12
& Windows 7 Home Premium

Thanks to Kohei. 
Mark this report as Duplicate of Bug 77990

Jacques

*** This bug has been marked as a duplicate of bug 77990 ***