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 my excel. I have tried to re-download the application however the problem still remains. 

 

Can anyone please help me regarding this? 

excel
Excel on Mac
office 365

8 Replies

  • 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

Resources