VLOOKUP on Matching Multiple Criteria

[p45cal]

Another, in D2 of the Result sheet:

=IFERROR(INDEX(Export!D$1:D$8,MATCH($A2 & "¬" & $B2 & "¬" & $C2,Export!$A$1:$A$8 & "¬" & Export!$B$1:$B$8 & "¬" & Export!$C$1:$C$8,0)),"")

copy across and down.

The attached contains that formula, but as a bonus there is another offering at cell H1, being a Power Query table which just needs to be right-clicked and Refreshed, also see note in cell F9 of the Export sheet.

Edit post posting: AAghhh, I've just noticed https://www.excelfox.com/forum/showt...tiple-Criteria although we've done it differently.