Bug 29426

Summary: VLOOKUP Results in #VALUE!
Product: POI Reporter: Rajesh S Krishnaiah <skrajesh>
Component: HSSFAssignee: POI Developers List <dev>
Severity: normal    
Priority: P3    
Version: 2.0-FINAL   
Target Milestone: ---   
Hardware: Other   
OS: Windows XP   
Bug Depends on:    
Bug Blocks: 34973    
Attachments: VLookUp Error

Description Rajesh S Krishnaiah 2004-06-07 14:26:21 UTC
I am trying to use the following formula in my java program:
cell.setCellFormula("VLOOKUP(A2, A1:Z2, 2, FALSE)");
The result of the above formula is #VALUE!.

But if I replace the first argument of the vlookup with an actual value instead 
of cell reference it works fine.
cell.setCellFormula("VLOOKUP(\"Test\", A1:Z2, 2, FALSE)");
Comment 1 Rajesh S Krishnaiah 2004-06-07 14:27:21 UTC
Created attachment 11778 [details]
VLookUp Error
Comment 2 Josh Micich 2008-05-05 11:39:23 UTC
Re-tested in 3.1-beta1.

This was probably fixed in bug 44675 (second part - if the parameter operand class is wrong Excel evaluates VLOOKUP to '#VALUE!')