On Jun 28, 3:38*pm, Claus Busch wrote:
Hi Ty,

Am Thu, 28 Jun 2012 13:00:28 -0700 (PDT) schrieb Ty:

System A
NA-SMG-SA-CARDS
NA-SMG-SA-EBZ
NA-SMG-SA-RAL
NA-SMG-SA-RAT
NA-SMG-SA-RNBAW

Sytem B
SCNCRDU
SCNEBZU
SCNRALU
SCNRATU
SCNRBU

system A in E2:E6, System B in C2:C6, then:
=IF(LEN(E2)=15,INDEX($C$2:$C$6,MATCH("*"&MID(E2,11 ,1)&MID(E2,13,1)&"*",$C$2*:$C$6,0)),INDEX($C$2:$C$ 6,MATCH("*"&MID(E2,11,4)&"*",$C$2:$C$6,0)))

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thanks,.. Excellent. This will do the vlookup and all in one cell. I
made some changes to match what I really have after I do a download in
a report. I have about 1300 rows for each system and placed them in
separate sheets. And C2 have System A and E2 is System B. I'm still
trying to figure out what this is doing.

And System B is the new system that has some errors in the column.
Trying to findout how many errors such as other system names listed
and blanks. Other system names such as SCNRALU on the same row as NA-
SMG-SA-RNBAW.


System A c2:c1300 System B e2:e1300
=IF(LEN(C2)=15,INDEX($e$2:$e
$1300,MATCH("*"&MID(c2,11,1)&MID(c2,13,1)&"*",$e$2 :$e$1300,0)),INDEX($e
$2:$e$1300,MATCH("*"&MID(c2,11,4)&"*",$e$2:$e$1300 ,0)))

Sheet for SCNRBU. I inserted Column D-Inserted the formula. I have
#N/A in Column D for the NA-SMG-SA-RNBAW in Col C and SCNRBU in Col
E. This is not correct. It should be a match on Row 2.

Long day here at work. I missed something.