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,)