Hi
I have a table of 16087 rows and 7 columns. and im strugling with similer names in column A and Vlookup that picks the first hit.
This is a dogbreed that have dogs with simple names and i want to pick right father/mother combinations based on age and probability to puppies.
Now i have these lookups in place
=VLOOKUP(D2;$A$2:$B$9;2;FALSE) "Father"
=VLOOKUP(F2;$A$2:$B$9;2;FALSE) "mother"
I have there names but i like to also add Reg nr
my table looks like this and are sorted on "Born" the date the puppies where born :
<colgroup><col span="7"></colgroup><tbody>
</tbody>
what i want is to pick the right "father_one" with the age nearest to the puppies but still older than the puppies (and with a age differanse less than 14 years had been nice to have)
Is there any functions i can combine to get this to work?
hope someone has any idee so i can get past this problem
br
Jimmy
I have a table of 16087 rows and 7 columns. and im strugling with similer names in column A and Vlookup that picks the first hit.
This is a dogbreed that have dogs with simple names and i want to pick right father/mother combinations based on age and probability to puppies.
Now i have these lookups in place
=VLOOKUP(D2;$A$2:$B$9;2;FALSE) "Father"
=VLOOKUP(F2;$A$2:$B$9;2;FALSE) "mother"
I have there names but i like to also add Reg nr
my table looks like this and are sorted on "Born" the date the puppies where born :
Name | Reg_Name | Reg_Father | Father | Reg_Mother | Mother | Born |
Father one | IS00000/00 | #N/A | not known | #N/A | not known | 12.06.1986 |
Mother one | IS00 | #N/A | not known | #N/A | not known | 12.06.1987 |
Father two | IS00000/01 | IS00000/00 | Father one | #N/A | not known | 24.06.1988 |
Father one | IS0001/12 | IS00000/00 | Father one | IS00 | mother one | 01.01.2012 |
Mother two | IS0001/13 | IS00000/01 | Father two | IS00 | mother one | 01.02.2013 |
puppy 1 | VIH 155 | IS00000/00 | Father one | IS0001/13 | mother two | 01.04.2015 |
puppy 2 | VIH 156 | IS00000/00 | Father one | IS0001/13 | mother two | 01.04.2015 |
puppy 3 | VIH 157 | IS00000/00 | Father one | IS0001/13 | mother two | 01.04.2015 |
<colgroup><col span="7"></colgroup><tbody>
</tbody>
what i want is to pick the right "father_one" with the age nearest to the puppies but still older than the puppies (and with a age differanse less than 14 years had been nice to have)
Is there any functions i can combine to get this to work?
hope someone has any idee so i can get past this problem
br
Jimmy