Excel: 'Is like' within formula

[GaryStone10]

Hi All

I have this formula below

=SUMPRODUCT(--(RAW_DATA!$B$4:$B$100=Dashboard!$I$10),--(RAW_DATA!$A$4:$A$100='Dashboard Data'!$A2),--(RAW_DATA!$C$4:$C$100=Dashboard!$I$10),--(RAW_DATA!$J$4:$J$100))

Which works fine, but....

I want it to pick up things that are not =Dashboard!$I$10 but start with that value.

Eg if Dashboard!$I$10 = Bob I want it to evaluate for all terms such as Bob1, Bob2, Bob3, etc.

Or to put it another way, I want to be able to use a Wildcard (*) with part of a formula.

 

[Andrew Poulsom]

Is it?

=SUMPRODUCT(--(LEFT(RAW_DATA!$B$4:$B$100,LEN(Dashboard!$I$10))=Dashboard!$I$10),--(RAW_DATA!$A$4:$A$100='Dashboard Data'!$A2),--(RAW_DATA!$C$4:$C$100=Dashboard!$I$10),--(RAW_DATA!$J$4:$J$100))

 

[onlyadrafter]

try

=SUMPRODUCT(--(LEFT(raw_data!$B$4:$B$100,LEN(Dashboard!$I$10))=Dashboard!$I$10),--(raw_data!$A$4:$A$100='Dashboard data'!$A2),--(raw_data!$C$4:$C$100=Dashboard!$I$10),--(raw_data!$J$4:$J$100))

 

[GaryStone10]

Is it?

=SUMPRODUCT(--(LEFT(RAW_DATA!$B$4:$B$100,LEN(Dashboard!$I$10))=Dashboard!$I$10),--(RAW_DATA!$A$4:$A$100='Dashboard Data'!$A2),--(RAW_DATA!$C$4:$C$100=Dashboard!$I$10),--(RAW_DATA!$J$4:$J$100))

It is indeed!

Many thanks.