Search code examples
if-statementgoogle-sheetsfiltergoogle-sheets-formulavlookup

Why is this Arrayformula based vlookup with multiple criteria is not working?


I've followed the instruction, but it doesn't work in my situation and I wonder why.

This is the formula:

=ARRAYFORMULA(VLOOKUP(B12&""&C12,F11:H29,3,0))

Here's a doc with a situation for tests: File


Solution

  • try:

    =ARRAYFORMULA(IFNA(VLOOKUP(B12:B29&C12:C29, {F11&G11, H11}, 2, 0)))
    

    enter image description here