Excel 2003 [Closed]

Report
-
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.

1 reply

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!