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.

"Bill Kuunders" wrote:

something like

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


--
Greetings from New Zealand

"mldancing" wrote in message
...
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.