UDF; Two Matches, then Sumproduct of Values

R

ryguy7272

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--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UDF for Two Matches and Sumproduct Results 9
Need Help with a VBA subroutine 0
Word macro that can call cells out of Excel for a find and replace 0
Two Matches, then Sumproduct of Values 16
Creating an ARRAY UDF 0
Create if partial match then copy and paste data from one cell to another 1
Sheet to sheet code Type Mismatch 6
MINIF UDF 4

Top