wildcard is not working?

[Dave]

I have a sheet with names and then in another column I
have numbers. I need to check the names and if that name
appears (even if it is with someone else's name it should
use the number in the column) For example it should pick
up Dave as well as Dave/Tim however it appears etc. The
formual works until I put in the wildcard?

=(SUMPRODUCT(('Data Input'!$F$4:$F$36="Dave")*('Data
Input'!$P$4:$P$36))+SUMPRODUCT(('Data Input'!
$G$4:$G$36="Dave")*('Data Input'!$P$4:$P$36)))

when I put in the wildcard in "*Dave*" or "*Dave/*" it
gives me zero as an answer. I would not like to change the
formulae as it is used in many places but want to put the
wildcard in correctly.

Thanks!

 

[Peo Sjoblom]

Wildcard does not work in your situation,
you can use

=SUMPRODUCT((ISNUMBER(SEARCH("Dave",'Data Input'!$F$4:$F$36)))*and so on

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)