Need to compare list 1 against list 2 then to display as in 3(also no duplication ie 20balarm not displayed twice)
List 1 will always be 4 letters at beginning and the rest can be either numbers or letters there may also be blanks in list 1
List 1
aaaa*******
bbbb*******
gggg****
dddd********
eeee****
ffff**********
list 2
aaaa = 20balarm
bbbb = 18calarm
cccc = 20balarm
dddd = 19balarm
eeee = 20balarm
ffff = 18calarm
gggg = 10dalarm
Display 3
20balarm
18calarm
10dalarm
19balarm
Many Thanks
Bookmarks