Well ... would you care to share the formulas?

Not sure I understand what the formulas used to create the data will

do to help, but here they are:

In Cell F2:

=IF(LEFT(D2,3)="LUC","ALCATEL-

LUCENT",IF(ISERROR(FIND("MdlrC",C2,1)),IF(ISERROR(FIND("OneBTS",C2,1)),IF(LEFT(D2,3)="MOT","MOTOROLA",IF(LEFT(D2,3)="NOR","NORTEL",IF(ISERROR(FIND("MiniC",C2,1)),IF(LEFT(E2,3)="NTN","NORTEL",""),"ALCATEL-

LUCENT") )),"ALCATEL-

LUCENT"),IF(LEFT(D2,3)="NOR","NORTEL","")))

In Cell G2:

=IF(ISERROR(FIND("MCPLR-INFIN",C2,1)), IF(LEFT(D2,3)="ALC","ALCATEL-

LUCENT",IF(LEFT(D2,6)="HUGHES","HUGHES NETWORK

SYSTEMS",IF(LEFT(D2,6)="METAWA","METAWAVE

COMMUNICATIONS",IF(ISERROR(FIND("SERIES_II",C2,1)),IF(LEFT(E2,3)="300","ALCATEL-

LUCENT",IF(LEFT(D2,3)="NOK","NOKIA","")),"ALCATEL-

LUCENT")))),"ERICSSON")

In Cell H2:

=IF(LEFT(D2,8)="COMMUNIC","CCI",IF(ISERROR(FIND("KS",E2,1)),IF(LEFT(D2,6)="ANDREW","ALCATEL-

LUCENT",IF(LEFT(E2,3)="NOR","NORTEL",IF(LEFT(E2,3)="910","MOTOROLA",IF(OR(LEFT(E2,3)="01D",LEFT(E2,3)="016"),"MOTOROLA",IF(LEFT(E2,3)="018","MOTOROLA",""))))),"ALCATEL-

LUCENT"))

In Cell I2:

=IF(LEFT(E2,3)="408","ALCATEL-

LUCENT",IF(LEFT(E2,3)="918","MOTOROLA",IF(ISERROR(FIND("ERIC",D2,1)),IF(LEFT(E2,3)="201","ALCATEL-

LUCENT",IF(LEFT(E2,3)="920","ALCATEL-

LUCENT",IF(LEFT(E2,3)="NTU","NORTEL",IF(LEFT(E2,3)="407","ALCATEL-

LUCENT",""))) ),"ERICSSON")))

In Cell J2:

=IF(LEFT(D2,3)="LUC","ALCATEL-

LUCENT",IF(ISERROR(FIND("NT",E2,1)),IF(ISERROR(FIND("KS",E2,1)),

IF(ISERROR(FIND("MicrC",C2,1)),

IF(ISERROR(FIND("OneBTS",C2,1)),IF(LEFT(E2,3)="918","MOTOROLA",""),"ALCATEL-

LUCENT"),IF(OR(LEFT(E2,3)="407",LEFT(E2,3)="408"),"ALCATEL-

LUCENT","")),"ALCATEL-LUCENT"),"NORTEL"))

And the formula that I had used from the suggestions above has been re-

written to accommodate the data being in columns F thru J is:

=IF(SUMPRODUCT((F2:I2<>"")/COUNTIF(F2:I2,F2:I2&""))=1,LOOKUP(2,1/

(F2:I2>0),F2:I2),"Mismatch")

Regards,

Steve