CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup
Evgeniy Grigoriev
Evgeniy Grigoriev

Reputation: 1

Automatically add data with VLOOKUP

I have two sheets. On the first sheet there are 2 columns: name and date of birth. On the second sheet in the first column, a drop-down list from the name on the first sheet.

How on the second sheet in the second column automatically add the date of birth of a person??

Upvotes: 0

Views: 52

Answers (2)

user11982798
user11982798

Reputation: 1908

Use like this, see the attached sample pict:

=filter ( VLOOKUP ( A2:A, filter ( Log!A2:B, Log!A2:A<>"" ), 2, 0), A2:A <> "")

Log Sheet

enter image description here

Working Sheet:

enter image description here

Upvotes: 0

player0
player0

Reputation: 1

use:

=VLOOKUP(A1, Sheet1!A:B, 2, 0)

for array use:

=ARRAYFORMULA(IFNA(VLOOKUP(A1:A, Sheet1!A:B, 2, 0)))

Upvotes: 1

Related Questions