Copying it from above gives me an error; without Bold: Paste it in Row 3.. I'm seeing it as E - F.

=IF(LEFT(A3,2)="BB",1,IF(LEFT(A3,2)="CU",2,IF(LEFT(A3,3)="PR:",3,IF(LEFT(A3 ,5)="SNEAK",4,IF(LEFT(A3,6)="PRECAP",5,IF(LEFT(A3,5)="RECAP",5,IF(LEFT(C3,1 )="L",6,IF(LEFT(A3,7)="Segment",7,IF(LEFT(A3,2)="NA",8,ISTEXT(D3))))))))) ) & " - " & IF(COUNT(SEARCH({"xco","cross"},A3)),"8")