https://bz.apache.org/bugzilla/show_bug.cgi?id=62275
--- Comment #9 from Javen O'Neal <one...@apache.org> --- (In reply to dolphin.in.the.sky.51 from comment #7) > In EXCEL, when the fourth argument of the vlookup function is "empty", > it operates in the same way as when FALSE is specified. https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 > Optionally, you can specify TRUE if you want an approximate > match or FALSE if you want an exact match of the return > value. If you don't specify anything, the default value will > always be TRUE or approximate match. In reply to Dominik Stadler from comment #8) > This was actually already fixed some time ago via r1836857, the given > test-case and some other cases work fine now. > try { > + isRangeLookup = LookupUtils.resolveRangeLookupArg(range_lookup, > srcRowIndex, srcColumnIndex); > + } catch(RuntimeException e) { > + isRangeLookup = true; > + } It appears that POI defaults the fourth argument to true if it's omitted. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org