Forum Discussion

Copper Contributor

Oct 24, 2020

VLOOKUP formula not working

So, I have downloaded excel on my MacBook however when I try to use formula (e.g. VLOOKUP) a pop-up will appear stating that there is a problem with the formula. I am not sure why this happens with ...

Copper Contributor

Oct 24, 2020

Hi Wyn,

So when I key in the formula, the first argument will disappear and I have tried to manually input the argument however it is also not working.

I am not sure why this happens.

Wyn Hopkins

MVP

Oct 24, 2020

Just try selecting the 2 columns on the workbook you’re referencing

mellmn
Copper Contributor
Oct 24, 2020
Wyn Hopkins
Hi Wyn,

I tried to select the columns but it is also not working.

Melissa
- Jihad Al-Jarady
  MCT
  Oct 24, 2020
  mellmn
  Hi mellmn,
  Replace the comma with semicolon in your formula, some verion of excel using that.
  Your formula should be like this =VLOOKUP(A7;A2:B5;2;0)
  by the way, is the problem only with vlookup or with all functions?
  
  Aljarady
  - mellmn
    Copper Contributor
    Oct 25, 2020
    Jihad Al-Jarady
    
    Hi Aljarady,
    
    The problem is for all functions. I have tried to replace the comma with semicolon and the formula works now. Thank you so much for your help!
    
    melissa
- SergeiBaklan
  Diamond Contributor
  Oct 24, 2020
  mellmn
  
  Are you sure your separator is comma, not semicolon? Other words
  
  =VLOOKUP(A7; A2:B5;2;0)
  - mellmn
    Copper Contributor
    Oct 25, 2020
    Hi Sergei,
    
    I have changed the separator to a semicolon and it works now. Thank you so much for your help!
    
    melissa