1

Can somebody help me what's wrong with this formula? (If I replace semicolons by comas I get an parsing error) Thanks in advance!

The formula:

=ARRAYFORMULA(VLOOKUP(E2&F2;{A:A&B:B;C:C};2;0))

enter image description here

luisa
  • 72
  • 8
  • In situations like this I usually create a combined lookup column `=A2&B2` then vlookup on that instead – Simeon Oct 17 '22 at 12:40

1 Answers1

2

instead of

A:A&B:B; C:C

use

A:A&B:B\ C:C

for more info see: locale differences in google sheets (documentation missing pages)

player0
  • 124,011
  • 12
  • 67
  • 124