Example:

First range (on first worksheet):
Col B has names, Col E has numbers
Scott 20
Clark 25
Jones 30

Second range (on another worksheet):
Col B has names, Col E has numbers
Scott 15
Davis 12
Jones 10

Since Clark is not on the second worksheet, I don't get any results for
Clark using my function....if it works right, it should yield 25, but it
isn't. Here's the function I'm using (I'm also using an ISERROR statement to
avoid N/A# errors from appearing)...what am I doing wrong?

=IF(ISERROR(VLOOKUP(C8,'Worksheet1'!$B$11:$M$150,4 ,FALSE)+VLOOKUP(C8,'Worksheet2'!$B$11:$M$150,4,FAL SE)),"",(VLOOKUP(C8,'Worksheet1'!$B$11:$M$150,4,FA LSE)+VLOOKUP(C8,'Worksheet2'!$B$11:$M$150,4,FALSE) ))

Thanks for any help anyone can offer