Changing cell number automatically according to another cell

[Rami100]

Good morning,

Please I need help in this excel sheet. (attached)

In Colomn B, I have mentioned 3 products.

Each one has a price:

ACUPX: 1000
ACUPY: 2000
ACUPZ: 3000

What I need is that the prices change automatically in Column D if we change the product mentioned in column B.

For example: if we change in column B4 ACUPZ to ACUPY the price change from 3000 to 2000.


Thanks for help,

 

[eduzs]

You need a range that contains the products and cost per unit and use a VLOOKUP.

 

[Dossfm0q]

In Sheet1

Book1
	A	B
1	ACUPX	1000
2	ACUPY	2000
3	ACUPZ	3000
4	ACUPA	4000
5	ACUPB	5000
6	ACUPC	6000
7	ACUPD	7000
8	ACUPE	8000
9	ACUPF	9000
Sheet1

In Sheet2

Book1
	A	B	C	D	E	F
1			QTY		Or	Or
2		ACUPX	2	2000	1000	1000
3		ACUPY	8	16000	2000	2000
4		ACUPZ	5	15000	3000	3000
Sheet2

Cell Formulas
Range	Formula
D2:D4	D2	=C2*IFERROR(VLOOKUP(B2,Sheet1!$A$1:$B$9,2,FALSE),"")
E2:E4	E2	=IFERROR(VLOOKUP(B2,Sheet1!$A$1:$B$9,2,FALSE),"")
F2:F4	F2	=IF(B2="ACUPX",1000,IF(B2="ACUPY",2000,IF(B2="ACUPZ",3000)))

 

[Rami100]

Big thanks friend that what I was trying to do

 

[Fluff]

For future reference
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Changing cell number automatically
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.