That means it is not finding the value in A1 in either sheet1 or sheet2.

What would you like to do in that circumstance, know about it and go fix
that problem, or assume 0?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AZExcelNewbie" wrote in message
...
I get a nice error message... #N/A

=VLOOKUP(A1,Sheet1!A:A,1)+VLOOKUP(A1,Sheet2!A:A,1)


"Bob Phillips" wrote:

Just do a simple VLOOKUP(... in first sheet ...)+VLOOKUP(... in second
sheet
....)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AZExcelNewbie" wrote in
message
...
Say I have three worksheets, two of them contain data which holds
names.
I
need to sum up a certain persons name as they appear in the two
different
worksheets in the third worksheet. How do I go about this? I've
tried
using
a SUMPRODUCT with a VLOOKUP, but I can't seem to get it right, PLEASE
HELP!