Excel column linking query

Closed
hollie2014 Posts 1 Registration date Wednesday February 12, 2014 Status Member Last seen February 12, 2014 - Feb 12, 2014 at 01:08 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 13, 2014 at 11:04 PM
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
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 13, 2014 at 11:04 PM
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
0