https://bz.apache.org/bugzilla/show_bug.cgi?id=63934
--- Comment #4 from Matthias Raschhofer <matthias.raschho...@gmail.com> --- Btw, there's a workaround for the issue: If you specify the range in the lookup table explicitly, both excel and the apache poi library can evaluate the formula just fine. E.g.: =VLOOKUP([@[Gender ]];Gender_lookup[[Gender input]:[Gender mod]];2;0) -- 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