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

in Introduction to Excel / Using Lookup Functions (Vlookup) to Fill the Database Sheet

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)

Ned Krastev

Instructor

Posted on:

15 Feb 2023

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

Helpful answer

Donald Trenholm

Posted on:

16 Feb 2023

Thanks that was it,

Helpful answer

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

Submit an answer

related questions