Extracting Data from an excel table

[David Wan]

I want to be able to have formulas already set up that will be able to extract data from another table based on 3 different conditions. The table from which the data will be extracted will be populated on a different sheet, then pasted onto this sheet. The plan is to have this sheet automatically extract the right data based on 3 conditions once the table is pasted.

A B C D E
1 2 3 4 5
5 3 5 6 8
8 3 1 5 7
4 6 2 8 9

If I were to paste the above table, I want to come up with a formula that would use conditions like A=1, and C=3, and D=4, then automatically return the value 5 for E. This is for the first line, it would also do the same thing for all the lines to automatically extract all the "E" column values.

Any help would be appreciated.
Thank you

 

[texasalynn]

try this
=if(and(A1=1,C1=3,D1=4),E1,0)

 

[David Wan]

Thanks. That works for just one of the lines. I want to automatically extract that data from all of the lines that match the conditions

 

[texasalynn]

what do you mean? Show me an example of the results you would expect