1

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

  • Does this answer your question? LEFT JOIN two and more tables in Google Sheets – Rubén Apr 15 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. – Paulo Mesquita Apr 16 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 at 14:55
0

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); ));""))}

| improve this answer | |
  • 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. – marikamitsos Apr 17 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.