Left or Mid

[julhs]

=IF($S49>0,INDEX($R$7:$R23,MATCH($S49,$AC$7:$AC23,11)))

I am using this and its returning pretty much what I want, but I would like to return everything except the first 6 letters of the returned text. My attempts so far to extend it with the inclusion of Left or Mid have resulted in #NAME error.

julhs

[TMS]

=RIGHT(IF($S49>0,INDEX($R$7:$R23,MATCH($S49,$AC$7:$AC23,11))),LEN(IF($S49>0,INDEX($R$7:$R23,MATCH($S49,$AC$7:$AC23,11))))-6)


Regards, TMS

[Haseeb Avarakkan]

Or,

=REPLACE(IF($S49>0,INDEX($R$7:$R23,MATCH($S49,$AC$7:$AC23,11)),""),1,6,"")

[julhs]

Thanks TMS & Haseed A,

Both work perfectly, so spoilt for choice.

Many thanks and good night.

julhs

[TMS]

You're welcome. Thanks for the rep.