Solved: Wildcards

[philfer]

This may seem like a really basic question but I have an IF statement in excel that goes like :-

=IF(B2="TMI*",1,0)

but it isnt finding TMI-New York

Does anyone know why not?

Thanks

[tpoynton]

I'm not sure how to implement wildcards in a formula like that, but this should work

=IF(LEFT(B2, 3) = "TMI",1,0)

[unmarkedhelicopter]

Excel formula interpret all sting values literally so TMI* <> TMIanything

[rory]

You could use:

=COUNTIF(B2,"TMI*")

[Norie]

Excel formula interpret all sting values literally so TMI* <> TMIanything
Not quite true.

Yes an IF formula will look for an exact match but COUNTIF or SUMIF can be used with wildcards.

[unmarkedhelicopter]

I didn't know that, thanks rory & Norie.