2

I have A and B.

Google working example here:

https://docs.google.com/spreadsheets/d/157x9Yg9tG2pmV-q4wZVn0NW1xas4VSin3zASbrCV3t4/edit?usp=sharing

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

3
  • Does this answer your question? LEFT JOIN two and more tables in Google Sheets Apr 15, 2020 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, 2020 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. Apr 16, 2020 at 14:55

1 Answer 1

1

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

={QUERY(SheetA!A1:G1)\QUERY(SheetB!A1:F1);
  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); ));""))}

1
  • 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, 2020 at 14:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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