Hi,

I just wanted to know if its possible to combine below 2 formula's:

1. =IF(LEFT(A2,2)="BB", 1, IF(LEFT(A2,2)="CU",2,IF(LEFT(A2,3)="PR:",3,IF(LEFT(A2,5)="SNEAK",4,IF(LEFT(A2,6)="PRECAP",5,IF(LEFT(A2,5)="RECAP" ,5,IF(LEFT(C2,1)="L",6,IF(LEFT(A2,7)="Segment",8,IF(ELFT(A2,2)="NA",9,ISTEX T(M2)))))))))

2. =IF(COUNT(SEARCH({"xco","cross"},A2)),"9")

Any suggestions.

Thanks!
RJ