https://bz.apache.org/bugzilla/show_bug.cgi?id=61841
--- Comment #3 from Javen O'Neal <one...@apache.org> --- Looking at the POI implementation of Vlookup.java, the class currently doesn't have a reference to the sheet that contains the lookup table. This will make a fix non-trivial. The function that creates the AreaEval that is passed to the evaluate function might have a reference to the lookup sheet. Caveats: lookup table may be contained in a different workbook or sheet than the cell that contains the formula that is being evaluated. -- 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