Resolved: error message "There's a problem with this formula"

Question

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?

Answer 1

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

Answer 2

Donald Trenholm

Super learner

Posted on:

16 Feb 2023

0

Thanks that was it,

Helpful answer

Resolved: error message "There's a problem with this formula"

Submit an answer

related questions