Hi,

I am sure this is a simple one but cant quite get my gear around it, firstly i need to set the conditional formatting in the first cell (A14) so that users can only input a certain string of a Project Number eg, PJ-06-0099-0001-09 or PJ-03-0077-0101-01 so that i always end up with (PJ-##-####-####-##)

Secondly i need another cell (J14) to look at the first cell (A14) and and from the the first set of numbers PJ-03, PJ-04, PJ-05 etc, display a number for the transaction code, T1, T2, T3 etc

T1 – PJ-03: Sales & Marketing
T2 – PJ-06: Installation & Commissioning
T3 – PJ-08: Chargeable Service Work
T4 – PJ-05: Warranty
T5 – PJ-02: Office Support, training, medical, holidays etc
T7 – PJ-04: R & D work

So PJ-06-0101-0099-00 would return a value of T2 and PJ-04-0099-0001-08 would return a value of T7

Hope i am making sense