Lookup

[Johnboy28]

Hi, Need a lookup that can match Week Price Number to product code? Example if week price number is "1" and product code is 12143 price would be $11.40. If week price number is "2" then price would be $9.00. Thank you

Week Price Number	1	1	2	3	4	5	6
Product Code	Description	Sales Price	Sales Price	Sales Price	Sales Price	Sales Price	Sales Price
12143	Pastry	$11.40	$9.00	$8.20	$5.00	$8.00	$8.50
12145	Meat	$9.00	$8.00	$8.15	$7.00	$5.00	$7.50
12251	Bread	$9.20	$8.50	$6.50	$6.25	$6.10	$6.80
12255	Flour	$9.00	$7.50	$7.00	$6.50	$6.25	$5.80
12256	Eggs	$9.15	$8.25	$8.00	$9.00	$8.00	$7.50
14902	Butter	$15.00	$14.00	$13.00	$10.00	$11.00	$10.55
Week Price Number	1
Price/kg	Product Code
$11.40	12143
??	12145
??	12251
??	12255
??	12256

 

[AhoyNC]

Try:

Book1
	A	B	C	D	E	F	G	H
1	Week Price Number	1	1	2	3	4	5	6
2	Product Code	Description	Sales Price	Sales Price	Sales Price	Sales Price	Sales Price	Sales Price
3	12143	Pastry	$11.40	$9.00	$8.20	$5.00	$8.00	$8.50
4	12145	Meat	$9.00	$8.00	$8.15	$7.00	$5.00	$7.50
5	12251	Bread	$9.20	$8.50	$6.50	$6.25	$6.10	$6.80
6	12255	Flour	$9.00	$7.50	$7.00	$6.50	$6.25	$5.80
7	12256	Eggs	$9.15	$8.25	$8.00	$9.00	$8.00	$7.50
8	14902	Butter	$15.00	$14.00	$13.00	$10.00	$11.00	$10.55
9
10
11	Week Price Number	2
12	Price/kg	Product Code
13	$9.00	12143
14	$8.00	12145
15	$8.50	12251
16	$7.50	12255
17	$8.25	12256
18	$14.00	14902
Sheet3

Cell Formulas
Range	Formula
A13:A18	A13	=INDEX($C$3:$H$8,MATCH($B13,$A$3:$A$8,0),MATCH($B$11,$C$1:$H$1,0))

 

[Johnboy28]

Try:

Book1
	A	B	C	D	E	F	G	H
1	Week Price Number	1	1	2	3	4	5	6
2	Product Code	Description	Sales Price	Sales Price	Sales Price	Sales Price	Sales Price	Sales Price
3	12143	Pastry	$11.40	$9.00	$8.20	$5.00	$8.00	$8.50
4	12145	Meat	$9.00	$8.00	$8.15	$7.00	$5.00	$7.50
5	12251	Bread	$9.20	$8.50	$6.50	$6.25	$6.10	$6.80
6	12255	Flour	$9.00	$7.50	$7.00	$6.50	$6.25	$5.80
7	12256	Eggs	$9.15	$8.25	$8.00	$9.00	$8.00	$7.50
8	14902	Butter	$15.00	$14.00	$13.00	$10.00	$11.00	$10.55
9
10
11	Week Price Number	2
12	Price/kg	Product Code
13	$9.00	12143
14	$8.00	12145
15	$8.50	12251
16	$7.50	12255
17	$8.25	12256
18	$14.00	14902
Sheet3

Cell Formulas
Range	Formula
A13:A18	A13	=INDEX($C$3:$H$8,MATCH($B13,$A$3:$A$8,0),MATCH($B$11,$C$1:$H$1,0))

Great - Thank you.

 

[AhoyNC]

You're welcome. Thanks for the feedback.