Nested if with "wild card"

[mldancing]

Would really appreciate it if you can help with the following nested if
example:

Example:

A1 B1
Large 2009 100
Medium 2009 200
Medium 2008 500
Large 2008 300
Other 2009 400

I want to set up a nested if formula to pick up the value in B1 if there is
the word
"Large" in A1 or if there's "Medium" in A1, else enter zero.

I was going with this but it didn't work:
=if(or(A1="Large*",A1="Medium*"),B1,0)

Can someone help? Thank you.

 

[Bill Kuunders]

something like

=IF(OR(LEFT(A1,4)="Larg",LEFT(A1,4)="medi"),B1,0)

 

[mldancing]

Thank you for you reply. In this example this formula would work.

Is it possible to use a wild card? 'cause there could be other combination
of description
such as Extra Large or Medium Small.

Thank you.

 

[barry houdini]

You can't use a wildcard with comparison operators like =, try usin
COUNTIF

=IF(SUM(COUNTIF(A1,{"*large*","*medium*"})),B1,"")

regards, barr

 

[Dave Peterson]

Bill's formula only looks at the first 4 characters in the cell (=left(a1,4)).
So you don't need a wild card.