G
Guest
I don't see the error:
=if(left(C2,4),ur01,if(left(C2,4),ur02 ,if(left(C2,4) ,ur03, ""), ""), "")
tia,
=if(left(C2,4),ur01,if(left(C2,4),ur02 ,if(left(C2,4) ,ur03, ""), ""), "")
tia,
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
sorry I left out some parts, I'll repost.
D
Don Guillett
Detail your situation.
maybe
if left(c2,4)="uro1","what",if(next
or
=CHOOSE(MID(E2,4,1),5,6,7,8)
maybe
if left(c2,4)="uro1","what",if(next
or
=CHOOSE(MID(E2,4,1),5,6,7,8)
G
Guest
I left out the quotation marks. Thanks!
Don Guillett said:Detail your situation.
maybe
if left(c2,4)="uro1","what",if(next
or
=CHOOSE(MID(E2,4,1),5,6,7,8)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
D
Don Guillett
try out the choose formula