Search code examples
google-sheetsgoogle-sheets-formulavlookup

VLookup Multiple Criteria Google Sheets

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

Solution

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