CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulavlookup
Elad Benda
Elad Benda

Reputation: 36664

VLOOKUP evaluates to an out of bounds range

Why do I get this error for the following formula?

=ARRAYFORMULA(VLOOKUP(Q8:Q1000&" "&"You",{A8:A1000&" "&B8:B1000,C8:C1000},3,false))

I have tried this as well

=ARRAYFORMULA(VLOOKUP(Q8:Q&" "&"You",{A8:A&" "&B8:B,C8:C},3,false))

Upvotes: 1

Views: 3089

Answers (1)

player0
player0

Reputation: 1

{A8:A1000&" "&B8:B1000, C8:C1000} is wide only two columns, therefore use:

=ARRAYFORMULA(IFNA(VLOOKUP(Q8:Q&" "&"You", {A8:A&" "&B8:B, C8:C}, 2, 0)))

Upvotes: 1

Related Questions