Forum Discussion

AlexRabiller42's avatar
AlexRabiller42
Copper Contributor
Apr 23, 2021

Vlookup formula

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.

Formulas and Functions

3 Replies

    • AlexRabiller42's avatar
      AlexRabiller42
      Copper Contributor
      Apr 23, 2021
      HansVogelaar Yes you are right, I am actually using a French language on the qwerty keyboard and I didn't realise I had to use a coma instead of a semi-colon between the arguments.
      Thanks a lot for your quick revert on the matter.
      • AlexRabiller42's avatar
        AlexRabiller42
        Copper Contributor
        Apr 23, 2021
        *I meant had to use a semi-colon instead of a coma 🙂

Resources