How to retrieve the VALUES from sheet1 to sheet2 according to the NAMES?

On Google Sheets, how to retrieve the VALUES from sheet1 to sheet2 according to the NAMES?

Generically speaking, would be something like:

GET VALUE FROM sheet1 WHERE NAME = sheet2!NAME

I tried some uses of MATCH and VLOOKUP without success.

Edit: Here an open sheet to test:

Upvotes: 0

Answers (2)

Reputation: 1

use this:

=ARRAYFORMULA(IFNA(VLOOKUP(A2:A; sheet1!A2:B; 2; 0)))

Upvotes: 1

Reputation: 1908

This is example to get value by name from sheet1 to sheet2

=filter(vlookup(A2:A;sheet1!A2:B;2;0);A2:A<>"")

Upvotes: 0