try out the choose formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Janis" wrote in message
...
I left out the quotation marks. Thanks!

"Don Guillett" wrote:

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

"Janis" wrote in message
...
I don't see the error:
=if(left(C2,4),ur01,if(left(C2,4),ur02 ,if(left(C2,4) ,ur03, ""), ""),
"")

tia,