I am trying to return numbers (which will total together) for specific text.
I want the formula to look for specific text (in one column) and return the
number that correspondes with that text. For Example:

=LOOKUP("CHURCHILL",$A17:$A50,C$17:C$65)+LOOKUP("J AGO",$A17:$A50,C$17:C$65)

the problem I'm running into is that if there is no match for the text, the
formula automatically returns the previous number. I just want it to return
a zero if there is no match. Please help if you can

Tom - Thank you very much, it worked, except it finally came back and said
formula is too long (there's over 50 names). Is there any way around this?

"Tom Ogilvy" wrote:

=If(iserror(VLOOKUP("CHURCHILL",$A17:$C50,3,False) ),0,VLOOKUP("CHURCHILL",$A
17:$C50,3,False))+If(iserror(VLOOKUP("JAGO",$A17:$ C50,3,False)),0,VLOOKUP("J
AGO",$A17:$C50,3,False))


Your two ranges should be the same length in cells. Maybe that was a typo.

--
Regards,
Tom Ogilvy

"kimberly_churchill" wrote in
message ...
I am trying to return numbers (which will total together) for specific
text.
I want the formula to look for specific text (in one column) and return
the
number that correspondes with that text. For Example:


=LOOKUP("CHURCHILL",$A17:$A50,C$17:C$65)+LOOKUP("J AGO",$A17:$A50,C$17:C$65)

the problem I'm running into is that if there is no match for the text,
the
formula automatically returns the previous number. I just want it to
return
a zero if there is no match. Please help if you can

=SUMPRODUCT(SUMIF($A$17:$A$50,Sheet1!A1:A50,$A$17: $A$50))

add another sheet (sheet1), then enter your 50 names there in A1:A50.

Locations are examples (it doesn't have to be on another sheet). Alter to
suit you situation.

--
Regards,
Tom Ogilvy


"kimberly_churchill" wrote in
message ...
Tom - Thank you very much, it worked, except it finally came back and said
formula is too long (there's over 50 names). Is there any way around
this?

"Tom Ogilvy" wrote:


=If(iserror(VLOOKUP("CHURCHILL",$A17:$C50,3,False) ),0,VLOOKUP("CHURCHILL",$A

17:$C50,3,False))+If(iserror(VLOOKUP("JAGO",$A17:$ C50,3,False)),0,VLOOKUP("J
AGO",$A17:$C50,3,False))


Your two ranges should be the same length in cells. Maybe that was a
typo.

--
Regards,
Tom Ogilvy

"kimberly_churchill"
wrote in
message ...
I am trying to return numbers (which will total together) for specific
text.
I want the formula to look for specific text (in one column) and
return
the
number that correspondes with that text. For Example:



=LOOKUP("CHURCHILL",$A17:$A50,C$17:C$65)+LOOKUP("J AGO",$A17:$A50,C$17:C$65)

the problem I'm running into is that if there is no match for the
text,
the
formula automatically returns the previous number. I just want it to
return
a zero if there is no match. Please help if you can