Search code examples
google-sheetsgoogle-sheets-formula

google sheet vlookup function analysis error

I have a google sheet:

A B C D E F
exercise date bicep exercise bicep
push 25-08-2023 push 2

in C2 I put the following formula: =VLOOKUP(A2,E2:F2,2,false) expecting seeing the value 2, but I get a generic error of Analysis error of the formula (the language is set to Italian, I've translated the message for you, so it can differ from the english one)

Solution

  • You may try either syntaxes and see what happens:

    =VLOOKUP(A2;E:F;2;)

     =VLOOKUP(A2,E:F,2,)