Apr 23 2021 01:25 AM
Hello Community,
When I am trying to enter a Vlook up formula as follows =vlookup(cell, and trying to enter the array I am getting the following error message as per attached.
No matter what spreadsheet I am using or different excel extension file (xls, xlxs..), as soon as I want to select an array this error message pops us like Excel is telling me "that if you don't want a formula" but I do want a formula. Since it is the first time that this happens, has anybody already had the same issue?
Thanks in advance,
Kind regards,
Alex.
Apr 23 2021 01:55 AM
@AlexRabiller42 Do you use comma as decimal separator? If so, use semi-colon between the arguments of a function:
=VLOOKUP(A39; ...
Apr 23 2021 02:02 AM