CODEWITHSUNDEEP
arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup
Mous
Mous

Reputation: 159

Link google sheet tabs based on Key Column

I'd like to merge two tabs into a master tab.

Based on the key column, is there a way to merge the both tabs into a master ?

I'm wondering if it's doable using the Query formula

Here is a sample https://docs.google.com/spreadsheets/d/14i8L0G_hD9bU6ErdKsPLgxIh3xosmbQ1lzi4ualDGR8/edit?usp=sharing

Upvotes: 1

Views: 56

Answers (1)

player0
player0

Reputation: 1

in your Master sheet paste this in A2

={'Réponses au formulaire 1'!B2:Q}

and this into Q2

=ARRAYFORMULA(IFNA(VLOOKUP(A2:A; 'Réponses au formulaire 2'!B:C; 2; 0)))

Upvotes: 1

Related Questions