VLOOKUP and SUMIF

[noren]

Hi,

I have 2 files. 1 File accesses information from the other using VLOOKUP. I am trying to find a formula which will do what the VLOOKUP does BUT without stopping at the first instance of the condition.
More specifically, Im trying to sum up numbers that match the critiria from the whole worksheet (1 tab).


example:
file1:

bart 10
lisa 10
bart 20
homer 10
lisa 5

file2:

bart 30
lisa 15
homer 10

In one file this would be a simple SUMIF, but when I need to access the other file using VLOOKUP, it sometimes returns the very annoying "#N/A", and then the result will always be "#N/A"

Any and all help is appriciated!

Thanks,
Oren

 

[Jonmo1]

I don't normally use the "--' that jon uses (I guess I should). multipling by one is required in my formula

Either Way gives exactly the same results. They both convert TRUE/FALSE to 1/0.

the "--" was just the way I first learned it, so it became habbit.