Import data from another sheet using ID but only some columns

Question

I have a google sheet like this :

And another one like this :

I want in the second google sheet to pull data from the first sheet that matches those IDs I have tried index & match, vlookup, lookup but none of them got me to my point especially with using importrange to pull data from the second file I couldn't solve my Thanks in advance for your help

This is where I am trying to make the magic happen if you are wondering : https://docs.google.com/spreadsheets/d/1TZYo641Av4SHaHLjSPuAZv3DSnVw0pqSubbtsiYw8Uk/

score 2 · Accepted Answer · answered Jan 15 '20 at 13:00

2

use:

=ARRAYFORMULA(IFNA(VLOOKUP(A2:A, {Mother!B:B, Mother!A:A, Mother!C:D}, {2,3,4}, 0)))

answered Jan 15 '20 at 13:00

player0

124,011
12
67
124

Import data from another sheet using ID but only some columns

1 Answers1