Excel column linking query [Closed]

Report
Posts
1
Registration date
Wednesday February 12, 2014
Status
Member
Last seen
February 12, 2014
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hi,

I would like to know how to link one column with another therefore having the second column recognise it at the same.
eg Typing a name in column A then have column B recognise that name and link the birth date with it in the next column.
Is this possible?

Thanks, Hollie

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
not clar.
if you have one sheet containing names and date of birth then in another sheete it is possible if type a name the date of ibirthof tat name comes in the next column same row

sheet1

name dob
aaa 1/1/2000
bbb 31/8/1989
this is source sheet
in sheet if you type aaa in A2 you can get dob in B2