I have A and B.

Google working example here:


Sheet A stores data about patients.

enter image description here

Sheet B contains data about patients' vital signs that are collected.

sheet B

I need to perform the equivalent of SQL Left Join on these two sheets, using ID column of both sheets as reference, such that the resulting C, would be:

enter image description here

  • Does this answer your question? LEFT JOIN two and more tables in Google Sheets
    – Rubén
    Apr 15 '20 at 21:48
  • Hi @Rubén, thank you for your comment. It seems so, but I am having difficulties in in adapting this solution for my specific problem. First, how to adjust the formula to add 6 instead of two columns?.Second, I need to make sure the right way to correct regional formatting differences between comma and semicolon in the array formula.
    – Greene
    Apr 16 '20 at 8:00
  • Please edit the question to add all the relevant details directly to it including a brief description of your search/research efforts.
    – Rubén
    Apr 16 '20 at 14:55

Please use the following refactored formula for your needs and your locale (Brazil):

  QUERY(ARRAYFORMULA(IFERROR(VLOOKUP(SheetA!A2:A11; SheetA!A2:G11; {1\2\3\4\5\6\7}; 0); "")))\
  QUERY(IFERROR(ARRAYFORMULA(IF(LEN(SheetA!A2:A11); VLOOKUP(SheetA!A2:A11; SheetB!A2:F11; {1\2\3\4\5\6}; 0); ));""))}

  • Glad I could help. Please remember that as per site guidelines when an answer addresses your question, accept it and even upvote it so others can benefit as well. Apr 17 '20 at 14:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.