Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses