Hi there,

I have two sets of data see below. I wish to match the second set of data.
For example:

Col A Col B Col D Col E
Stock Code Stock Description Stock Code Stock Description
AAA Hat ABC (require
calculation shld = Glasses)
ABA Cap AAA
"
ABC Glasses ABA
"

the data is not sorted. All I wish to have is that column E should match up
with the right stock code and it's description like Col A and Col B.

PLease Help

Regards
Steve M