Excel 2003

Hello,


In one worbook (Best Price) I have the following data where Coloumn A, Row 1 is a heading (Range Code) and the data starts from A2.

Row Coloumn
A
1 Range Code
2 01AC
3 01BC
4 01CC
5 01HC


Below is data from another workbook (Lable Price).

Row Coloumn Coloumn
A B
1 Range Code Lable Code
2 01AC 01AC
3 01AC 2BL
4 01AC 35W4
5 01AC 5AF0
6 01BC K0MC
7 01BC 00PC
8 01BC 00TC
9 01CC PBF6
10 01HC 02T3
11 01HC 45Y7
12 01HC U9NB



I want to copy all the values in coloumn B in workbook Lable Price into workbook (Best Price) if the values in coloumn A (workbook Best Price) is equal to the values in coloumn A of workbook Best Price.

You will see that there are a few Lable codes (Lable Price workbook) associated with A2 and so on.