Paste into column C

=IF(AND($A:$A="AXUK20580",$B:$B=""),"Possible Circuit")

Pull down column C

Paste into column D

=IF(AND($A:$A="BUSHI LIBA000768",$B:$B="01589872568"),"Possible
ISDN/Pair Gain")

Paste into column E

=IF(AND($A:$A="UNABLE TO LOCATE",$B:$B="FAULTY PAIR"),"Faulty -
Unknown")

and so on, then merge the columns at the end.

Like I said messy, and I'm sure someone else can come up with something
better


--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
View this thread: http://www.excelforum.com/showthread...hreadid=524734