Bug 29426 - VLOOKUP Results in #VALUE!
Summary: VLOOKUP Results in #VALUE!
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-FINAL
Hardware: Other Windows XP
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Blocks: 34973
  Show dependency tree
Reported: 2004-06-07 14:26 UTC by Rajesh S Krishnaiah
Modified: 2008-05-05 11:39 UTC (History)
0 users

VLookUp Error (1.27 KB, text/plain)
2004-06-07 14:27 UTC, Rajesh S Krishnaiah

Note You need to log in before you can comment on or make changes to this bug.
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!')