I want to used and formula in Excel and the formula go like this:
=XLOOKUP(I118&E118, $A$8:$A$111&$F$8:$F$111,$P$8:$P$111)
=XLOOKUP(Value1&Value2, Range1 & Range2, RangeWhereisTheResult)
I put this formula in neatbeans java like this:
cell.setCellFormula("XLOOKUP(I118&E118, $A$8:$A$111&$F$8:$F$111,$P$8:$P$111)");
buy what i get in the excel is this:
=@XLOOKUP(I118&E118,@ $A$8:$A$111&@$F$8:$F$111,$P$8:$P$111)
I want to know how to avoid those @
;