UDF; Two Matches, then Sumproduct of Values
 

Am trying to come up with a way to match names in Column A of Sheet2 with
names in Column E of Sheet1. If there is a match there, then match names in
Column C of Sheet2 with names in Column C of Sheet3, and sum the values, in
Column V of Sheet1, that match this name!

I uploadad a file to show an example of what I am trying to achieve.
Here is a sample:
http://rs173.rapidshare.com/files/196921830/sample.xls

In the sample file, I was trying to get Cell M2 to be 4500. I'm sure it can
be done with a UDF. I tried several preset functions, and went to the Excel
- Worksheet Functions group earlier today. A solution still eludes me.

Please help!

Thanks,
Ryan--



--
RyGuy