formula help
 

A B C
1 US JEFF SMI
2 UW LISA SMI
3 WJ MIKE BIS
4 WF LISA BIS

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

formula help
 

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

Forgot to add that.

"TMF in MN" wrote:

A B C
1 US JEFF SMI
2 UW LISA SMI
3 WJ MIKE BIS
4 WF LISA BIS

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

formula help
 

Try this:

For a value in A1
C1: =IF(LEFT(A1,1)="U","SMI","BIS")

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

XL2002, WinXP


"TMF in MN" wrote:

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

Forgot to add that.

"TMF in MN" wrote:

A B C
1 US JEFF SMI
2 UW LISA SMI
3 WJ MIKE BIS
4 WF LISA BIS

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