Combination with IFERROR and VLOOKUP from another sheet does not return a correct value

vinci1it2000 / formulas

Excel formulas interpreter in Python.

https://formulas.readthedocs.io/

European Union Public License 1.1

342 stars 75 forks source link

Closed proexcuse closed 1 year ago

proexcuse commented 2 years ago

Hi,

formulas.Parser() cannot handle the combination with IFERROR and VLOOKUP from another sheet. It does not get a correct value on the excel file.

This bug was originally found in openpyxl. To reproduce the bug, see the URL below. https://foss.heptapod.net/openpyxl/openpyxl/-/issues/1715

vinci1it2000 commented 2 years ago

Can you share the input file?