| Summary: | VLOOKUP Results in #VALUE! | ||
|---|---|---|---|
| Product: | POI | Reporter: | Rajesh S Krishnaiah <skrajesh> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | P3 | ||
| Version: | 2.0-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | Other | ||
| OS: | Windows XP | ||
| Bug Depends on: | |||
| Bug Blocks: | 34973 | ||
| Attachments: | VLookUp Error | ||
Created attachment 11778 [details]
VLookUp Error
|
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)");