hi all!

i am having two worksheets. sheet1COL"A" having some defined values &
sheet1COL"B" having some related defined names.

sheet2 COL"A" having the same defined values as in sheet1 but randomly
repetitive and COL"B" having names but entirely different with
sheet1COL"B".

what i want is to replace the names in sheet2COL"B" with the related
difined names as in sheet1COL"B"!

example

sheet1
COL"A" COL"B"
10 aaa
20 bbb
30 ccc
40 ddd
50 eee

sheet2
COL"A" COL"B"
10 abc
20 bca
10 cab
30 cba
40 xyz
50 yzx
20 mno


result expected
sheet2
COL"A" COL"B"
10 aaa
20 bbb
10 aaa
30 ccc
40 ddd
50 eee
20 bbb



help pl?

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=508493