Forum Discussion

mellmn's avatar
mellmn
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 ...
excel
Excel on Mac
office 365
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Oct 24, 2020
Hi

It looks like you're missing the first argument of the formula .

E.g Needs to be =VLOOKUP(A2, range, 2, 0 )

Wyn
[MVP]
  • mellmn's avatar
    mellmn
    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's avatar
      Wyn Hopkins
      MVP
      Oct 24, 2020
      Just try selecting the 2 columns on the workbook you’re referencing
      • mellmn's avatar
        mellmn
        Copper Contributor
        Oct 24, 2020

        Wyn Hopkins 

        Hi Wyn, 

         

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

         

        Melissa

Resources