VLOOKUP for multiple results

Hi, Rob

First: You need the type of formula entered below.
=SUMPRODUCT(--(A1:A10=$A$1),B1:B10)

Second: It works by checking the values in one column and adding corresponding values in another column. Those 2 columns need to be listed individually. Consequently, you can't reference a multi-column range (TAB2 or A1:B10).

Third: If the Tab2 range is on a different sheet, then you'll need to reference that sheet in the formula:
=SUMPRODUCT(--(Sheet2!A1:A10=$A$1),Sheet2!B1:B10)

OR

You could create 2 named ranges on Sheet2 and reference them:
=SUMPRODUCT(--(Tab2FirstCol=$A$1),Tab2SecondCol)

Am I helping, yet?

Ron

I'm sure that you are helping, it's just that I'm not the greatest with Excel. I really do appreciate your help though. Right now I'm at home and the spreadsheet is at work. I'll try to wrap my brain around your suggestions and get back with you. Thanks again!

Ya, know....after looking at your example, the SUMIF function would be the better approach. You'd still need to reference 2 ranges, though. Put this function somewhere on Sheet1 (or whatever sheet Tab1 is on).
=SUMIF(Sheet2!$A$1:$A$10,A1,Sheet2!$B$1:$B$10)

That function is the more elegant way to calculate what you want.
If the Tab2 range is not on Sheet2, replace the Sheet2 reference with the correct sheet name.


Regards,
Ron

=SUMIF(RPC!$A$1:$A$1927,A1,epay!$F$1:$F$1194)

This is exactly the formula I tried. It returns 0, but it should be returning $129.30.
It resides on the RPC tab. Any idea what I'm doing wrong?

Thank you very much for all your help! I modified your formula to work, here it is:

=IF(VLOOKUP(A2,epay,1)=A2,SUMIF(epay!A:A,A2,epay!F:F),0)

Thanks again!

Rob

I'm glad you figured it out.

One question, two comments:

1)By skipping the 4th argument of the VLookup, it defaults to an approximate match....Is that OK?
IF NO, then you need:
=IF(VLOOKUP(A2,epay,1,0)=A2,SUMIF(epay!A:A,A2,epay!F :F),0)

2)Do you have a Sheet AND a Range each named epay? I usually try to avoid that situation.

3)I'm pretty sure you could cull your formula down to:
=SUMIF(epay!A:A,A2,epay!F:F)

Regards,
Ron