Help needed with excel function

Ziil

Estimable
Mar 26, 2014
12
0
4,560
0
Question about excel function, which one to use and how. If I have four columns ( family_id; father_name; mother_name; child_id) in sheet1, and sheet2 I have two columns(child_name; child_id).
For example:
sheet1: family_id/father_name/mother_name/child_id
111 father1 mother1 01
222 father2 mother2 02
333 father2 mother2 03

sheet2: child:name/child:id
child1 01
child2 01
child3 01
child4 02
child5 03
child6 03

How to get name_id value from sheet1 to sheet2? The function should compare the cell values I think? The result in sheet2 should be like this:

child1 01 111
child2 01 111
child3 01 111
child4 02 222
child5 03 333
child6 03 333

Hope someone can help me, many thanks!
 
Thread starter Similar threads Forum Replies Date
L Apps General Discussion 0
L Apps General Discussion 4
S Apps General Discussion 4
M Apps General Discussion 4
F Apps General Discussion 3
S Apps General Discussion 1
K Apps General Discussion 6
J Apps General Discussion 2
rimartic Apps General Discussion 2
F Apps General Discussion 2
L Apps General Discussion 5
H Apps General Discussion 13
S Apps General Discussion 3
D Apps General Discussion 2
MysteryManX93 Apps General Discussion 4
K Apps General Discussion 4
M Apps General Discussion 1
G Apps General Discussion 1
C Apps General Discussion 3
L Apps General Discussion 6

ASK THE COMMUNITY