CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulavlookuparray-formulasstring-concatenation
Ehab
Ehab

Reputation: 15

Concatenate two VLOOKUP arrays

I have two columns as arrays:
Column (A) = ArrayFormula(ifna(VLOOKUP(F2:F,Auditors!A:B,2,0)))
Column (B) = ArrayFormula(ifna(VLOOKUP(G2:G,Supervisor!A:B,2,0)))

The only way is to concatenate them and copy paste to the end of column, but I need help to concatenate them as a new array separated by ,:
A,B

Upvotes: 0

Views: 371

Answers (1)

ZygD
ZygD

Reputation: 24356

Do you need concatenation like this?

=ArrayFormula(ifna(VLOOKUP(F2:F,Auditors!A:B,2,0) & ", " & VLOOKUP(G2:G,Supervisor!A:B,2,0)))

Upvotes: 1

Related Questions