software

A B C
1 US JEFFSMI
2 UW LISASMI
3 WJ MIKEBIS
4 WF LISABIS

I would like a formula in column C that returns the SMI value when column A
begins with a U but the second digit is variable.

THANK YOU!
TF

OH!! And if column A doesn't begin with a U, the value should return the BIS

Forgot to add that.

quot;TMF in MNquot; wrote:

gt; A B C
gt; 1 US JEFFSMI
gt; 2 UW LISASMI
gt; 3 WJ MIKEBIS
gt; 4 WF LISABIS
gt;
gt; I would like a formula in column C that returns the SMI value when column A
gt; begins with a U but the second digit is variable.
gt;
gt; THANK YOU!
gt; TF

Try this:

For a value in A1
C1: =IF(LEFT(A1,1)=quot;Uquot;,quot;SMIquot;,quot;BISquot;)

Does that help?
***********
Regards,
Ron

XL2002, WinXPquot;TMF in MNquot; wrote:

gt; OH!! And if column A doesn't begin with a U, the value should return the BIS
gt;
gt; Forgot to add that.
gt;
gt; quot;TMF in MNquot; wrote:
gt;
gt; gt; A B C
gt; gt; 1 US JEFFSMI
gt; gt; 2 UW LISASMI
gt; gt; 3 WJ MIKEBIS
gt; gt; 4 WF LISABIS
gt; gt;
gt; gt; I would like a formula in column C that returns the SMI value when column A
gt; gt; begins with a U but the second digit is variable.
gt; gt;
gt; gt; THANK YOU!
gt; gt; TF