formulas

[Guest]

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.

 

[Guest]

I don't have excel here to test this on, but I think you want something like
this:

Let's say you have the SIRE in A2:A100 and the DAM in B2:B100 and the EPD
(whatever that is) in C2:C100 on Sheet1

On another sheet, you have Sire in A2, DAM in B2 and you want the average
EPD in C2.

Try this in C2:

=average(if(Sheet1!A2:A100 = A2, if (Sheet1:B2:B100 = B2, C2:C100)))

COmmit with CTRL SHIFT ENTER