Hi folks, I have an issue with vlookup on table. im trying to get the vlookup result in another sheet by referencing through Gender_lookup table. I am using formula =VLOOKUP(TRIM(CLEAN([@[Gender ]])),Gender_lookup,2,0) which takes Gender value from current row in my table and checks for corresponding Gender value in Gender_lookup table in another sheet to return answer. i have raised same issue in bugzilla : https://bz.apache.org/bugzilla/show_bug.cgi?id=63934 for reference with all attachments for reproducing issue easily.
I tried evaluating with XSSFFormulaEvaluator.evaluateAllFormulaCells(workbook); which gives exception as org.apache.poi.ss.formula.FormulaParseException: The column doesn't exist in table Gender_lookup. I need a solution without altering formula in excel if possible. Please help me with your valuable solution.im attaching here screenshot and sample file to test. Vlookup.java <http://apache-poi.1045710.n5.nabble.com/file/t340747/Vlookup.java> VlookupBug.xlsx <http://apache-poi.1045710.n5.nabble.com/file/t340747/VlookupBug.xlsx> <http://apache-poi.1045710.n5.nabble.com/file/t340747/TableBug.png> -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
