Hello,
I’ve been trying to fill up a excel file with datatables that have excel formulas in them, some of the formulas are accepted nicely, but others, like VLOOKUP causes me troubles, writing the formulas directly on the excel directly should be the latest option, since the excel can have up to thousands of entries that require this formulas.
Any suggestions are welcome.
Welcome to the community
What are you trying to write and where exactly are you getting the error
Cheers
hello,
The formula that causes error is: =+VLOOKUP(NXXX;BBDD!$A$2:$N$334;4;0)
(the Xs symbolize the number of the cell)
the error happens on the write range, I know this formula is the one that causes the error because not writing that formula let’s me write the range.
Why is there a + before vlookup can you remov eit and try
Also basicaly try using comma insteqd of semi colon that should solve
Cheers
oh my god thank you so much!
the + seems to be required, can’t go without writing it, but replacing semicolon with commas fix it
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.