# Excel 2003 [Closed]

-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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.

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
in best price sheet in B2 type this formula

=VLOOKUP(A2,'lable price'!\$A\$1:\$B\$12,2,0)

copy B2 down