Can anybody help me, I don't know where the issue is. I get the following error message: "VLOOKUP evaluates to an out-of-bounds range."
The range to search in is on another sheet.
your formula should be:
=ARRAYFORMULA(IFNA(VLOOKUP(B1:B&C1:C, {Sheet1!A:A&Sheet1!B:B, Sheet1!C:C}, 2, 0)))