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.