How do i return multiple matching columns into 1 column with VLOOKUP

Question

How do i return multiple matching columns into 1 column with VLOOKUP

=Arrayformula(if(len(A9:A), iferror(vlookup(B9:B, 'Concat Sheet Data'!A9:Q, {2,3}, FALSE)),))

Would like to return Column 2,3 into a single column.

Link to worksheet: https://docs.google.com/spreadsheets/d/1rMO4BU1vPJFFHPGELA_p3Z1BzJhFUt7se4v_XoozNu4/edit?usp=sharing

Is this possible?

Thanks.

Answer 1

Try:

=ArrayFormula(if(LEN(A:A),VLOOKUP(A:A,{E:E,F:F&G:G},2,0),""))

Based on the sample sheet:

=Arrayformula(if(len(A2:A), iferror(vlookup(B2:B, {'Concat Sheet Data'!A2:A,'Concat Sheet Data'!B2:B&'Concat Sheet Data'!C2:C}, 2, FALSE)),))

Answer 2

Use the fuction =FLATTEN() to join columns into one.