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.
Asked
Active
Viewed 75 times
1 Answers
3
your formula should be:
=ARRAYFORMULA(IFNA(VLOOKUP(B1:B&C1:C, {Sheet1!A:A&Sheet1!B:B, Sheet1!C:C}, 2, 0)))
player0
- 124,011
- 12
- 67
- 124