Resolved: error message "There's a problem with this formula"
I put the exact formula in and I keep getting an error message "There's a problem with this formula"
+VLOOKUP($B4;'1.1 FY2016'!$C$5:$E$61;2;false). Also when I tried to enter the table_array from the 2016 page, I had to change the ; to , after $B4 so I could get there. What's going on?
2 answers ( 2 marked as helpful)
Hi Donald,
In some countries, the default settings are set to use , as a formula argument separator instead of ;
This is probably why you receive error messages when you enter a formula.
Best,
Ned
Thanks that was it,