Wildcard in an If statement

[Amileaux]

Does a wildcard (* or ?) work in an if statement? For example in A1 I have the word "nextlevel" (wo the ""). In A2 I have: If(A1="nex*","Ok","No"). I have even tried If(A1="=nex*","ok","no"). In both instances I get "no", when I should be getting "ok". I figured out a work around using the left function - but still think the if statement should have worked.

A related question, when would I use "nex*" versus "=nex*"?

Thank you. Marie

 

[Rick Rothstein]

Col A Col B Col C
Row 1 12/31/12 Online Payment3009954333 To MrExcel 12/31 $100.00
Row 2 12/22/12 Online Payment3009912121 To Apple Store 12/22 $200.00

My thought was to write a formul in Col D, Row 1 that says: =If(B1="*MrExcel*", +C1,0) where the * is a wildcard. When I do that,

You can do it this way...

=IF(COUNTIF(B1,"*MrExcel*"),C1,0)

 

[Aladin Akyurek]

It may be easier to understand my dilemma if you consider this look at the original spreadsheet:

	Column A<o></o>	Column B<o></o>	Column C<o></o>
Row 1<o></o>	1/11/2012<o></o>	Online Paymentxxx54333 To MrExcel 01/11<o></o>	$ 100.00 <o></o>
Row 2<o></o>	1/12/2012<o></o>	Online Paymentxxx11221 To Apple 01/12<o></o>	$ 50.00 <o></o>

<tbody>
</tbody>

E2: mrxecel
E3: apple
Etc...

F2, just enter and copy down:

=SUMIF($B$2:$B$4,"*"&E2&"*",$C$2:$C$4)

Also possible...

D2, just enter & copy down:

=LOOKUP(9.99999999999999E+307,SEARCH(PayeeList,C2),PayeeList)

 

[nealetr]

Thank you.

 

[nealetr]

Thank you so much. Works perfectly.