[SOLVED] Help with multiple IF functions and possible lookup functions.

Hey guys,

Still getting to grips with formulas here and wondering if you can help.

I'll try and describe the situation as best I can.

I have 5 (A-E) columns and I'm working on filling colum E, which will be an average of some selected values in the other columns

For E2 for example, I need it to look through column A and find any values equal to that of A2, from those rows which are true (equal) I need it to look in column C and find values equal to those in C2, for those which are true to both these (there should be three) I then need it to look in repective cells in column D, sum them and then divide by 3, thus getting the average of those involved.

If I haven't explained this very well, or more clarification is needed let me know. Otherwise any help would be much appreshiated!

Cheers.