matching data

[Steve M]

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

 

[Stefi]

In E2:
=VLOOKUP(C2,$A$2:$B$4,2,FALSE)
Apply your really last cell in place of $B$4 and fill down until it!

Regards,
Stefi