C
Cowboy
I would like to make a workbook or worksheet in excel 2003 that i can enter
epd data on beef cattle. Have the sire's listed in one table and the dam's
listed in another table. then in the third table be able to type in the dam's
name and the sires name and it give me an estimate of the offsprings epd's
which is just an aveage af the sire and the dam. When I type in the sire name
and dam name i would like it to lookup the information from the first two
tables and apply the aproprate formula to get the average. I know a little
bit about excel and can make it do simple formulas, and make the formulas.
Can excel do this or would it be better with something like access.
Thanks.
epd data on beef cattle. Have the sire's listed in one table and the dam's
listed in another table. then in the third table be able to type in the dam's
name and the sires name and it give me an estimate of the offsprings epd's
which is just an aveage af the sire and the dam. When I type in the sire name
and dam name i would like it to lookup the information from the first two
tables and apply the aproprate formula to get the average. I know a little
bit about excel and can make it do simple formulas, and make the formulas.
Can excel do this or would it be better with something like access.
Thanks.