LOOKUP Help!!!

From: kimberly_churchill <kimberly_churchill@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 7 Apr 2005 06:59:06 -0700

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("JAGO",$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
.

Follow-Ups:
- Re: LOOKUP Help!!!
  - From: Kremti
- Re: LOOKUP Help!!!
  - From: Tom Ogilvy

Prev by Date: Re: referencing a name from another book
Next by Date: Re: Looking for Rod over in the corner...
Previous by thread: Counting columns using VBA
Next by thread: Re: LOOKUP Help!!!
Index(es):
- Date
- Thread