ExcelBanter - matching data

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - matching data (https://www.excelbanter.com/new-users-excel/50975-matching-data.html)

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

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

"Steve M" wrote:

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