E
EngelseBoer
I have an excel file that now contains 37,000 + lines of entry on a dog breed
column A = name
column B = Reg. Nr
column C = M/F
Column D = (currently Blank) but represent the Sire
Column E = Sire's Reg Nr
Column F = (currently Blank) but represent the Dam
Column G = Dam's Reg. Nr
If say at row 100 -- dog XYZ has the sire with the Nr = 1234567 (in E)
I need column D - to compare that number in E100 with ALL those in B
and return the name(in D100) from A where the matching Nr is found in B
eg..
A B C D E
100 Sheila 3214 fem 1234567
120 Bob 6578 male
150 Toska 98765 fem
200 Millie 87654 fem
270 Duke 1234567 male
510 King 32768 male
766 Butch 8769 male
D100 must now return the name "Duke"
I don't know what command to use to do this with... or how ...
Thanks and regards
Malcolm
column A = name
column B = Reg. Nr
column C = M/F
Column D = (currently Blank) but represent the Sire
Column E = Sire's Reg Nr
Column F = (currently Blank) but represent the Dam
Column G = Dam's Reg. Nr
If say at row 100 -- dog XYZ has the sire with the Nr = 1234567 (in E)
I need column D - to compare that number in E100 with ALL those in B
and return the name(in D100) from A where the matching Nr is found in B
eg..
A B C D E
100 Sheila 3214 fem 1234567
120 Bob 6578 male
150 Toska 98765 fem
200 Millie 87654 fem
270 Duke 1234567 male
510 King 32768 male
766 Butch 8769 male
D100 must now return the name "Duke"
I don't know what command to use to do this with... or how ...
Thanks and regards
Malcolm