I am trying to use the HLOOKUP excel formula from my c# code and when I try to open the generated excel file it gives me an incorrect formula error and it deletes it.
How should I write the HLOOKUP formula correctly so that excel understands it?
According to the epplus documentation at https://github.com/EPPlusSoftware/EPPlus/wiki/Supported-Functions, the HLOOKUP formula is supported but I can't find a way to not get an error.
This is my code:
ws.Cells[15,1].Formula = "=HLOOKUP(10;$F$10:$H$20; 6; FALSE)";
Can someone please help us to resolve this issue?