CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulavlookup
The_Train
The_Train

Reputation: 331

VLOOKUP in multiple ranges Google Sheets

I have a VLOOKUP formula to lookup from a different sheet as below:

=ARRAYFORMULA(IFERROR(VLOOKUP(B2:B6,Sheet3!A2:C,2,0)))

I would now like to expand the data on Sheet 3 but would like the next batch of data to be in range E2:G. Is it possible to have a VLOOKUP across 2 different ranges like this?

I've done lots of google searching without any joy tonight so thought I'd ask the question on here to make sure I'm not trying the impossible.

Upvotes: 2

Views: 6149

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(IFNA(VLOOKUP(B2:B6, {Sheet3!A2:C; Sheet3!E2:G}, 2, 0)))

Upvotes: 3

Related Questions