Search code examples
arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup

Link google sheet tabs based on Key Column

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

  • The 1st tab header range goes from A1:Q1
  • The 2nd tab header range goes from A1:C1
  • The key column : B

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

Solution

  • 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)))