org.apache.poi.ss.formula.FormulaParseException: The column doesn't exist in lookup table
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
org.apache.poi.ss.formula.FormulaParseException: The column doesn't exist in
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.