Entering values automatically according to another ones.

[yasmin97]

I have an excel which has price points (like in the first table),each price point stands for a price..
and I have second excel which has the product codes and pricepoints..
I need a code to convert the pricepoints in the second table to prices..

[TABLE="width: 500"]
<tbody>[TR]
[TD]Pricepoint[/TD]
[TD]price[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]120[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]150[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Poductcode[/TD]
[TD]pricepoint[/TD]
[/TR]
[TR]
[TD]514526[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]514368[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

Thank you in advance

 

[Michael M]

Like this

Excel 2007
	A	B	C
1	Pricepoint	price
2	1	100
3	2	120
4	3	150
5
6
7	Poductcode	pricepoint	$ value
8	514526	3	150
9	514368	1	100
Sheet2

Cell Formulas
Range	Formula
C8	=VLOOKUP(B8,$A$2:$B$4,2,0)
C9	=VLOOKUP(B9,$A$2:$B$4,2,0)

 

[Max1616]

Is your table with product codes in a separate sheet or a separate workbook? I would recommend using an index match. Here is an example of an index match where I am looking up values from column B in one spreadsheet and returning the look up values in a different spreadsheet:
=INDEX('Z:\[Book1.xlsx]Sheet1'!$B$1:$B$5,MATCH(B1,'Z:\[Book1.xlsx]Sheet1'!$A$1:$A$5))

It's hard for me to help without a more specific example of your book and sheet names of where your tables are located.

Index Match is set up like this:
INDEX(X:X,MATCH(Y,Z:Z))

where:
X:X = Array which contains the value you would like to return
Y = The look up value or in this case the pricepoint
Z:Z = The Array of the values you are looking up against

So let T1 be table 1 and T2 be table 2:
INDEX(T1B2:T2B4,MATCH(T2A2,T1A2:T1A4))