Changing cell number automatically according to another cell

Rami100

New Member
Joined
Jan 23, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
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,
smile.gif
 

Attachments

  • Untitled.jpg
    Untitled.jpg
    68.8 KB · Views: 3

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

eduzs

Well-known Member
Joined
Jul 6, 2014
Messages
690
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
You need a range that contains the products and cost per unit and use a VLOOKUP.
 

Dossfm0q

Banned User
Joined
Mar 9, 2009
Messages
570
Office Version
  1. 2019
Platform
  1. Windows
In Sheet1
Book1
AB
1ACUPX1000
2ACUPY2000
3ACUPZ3000
4ACUPA4000
5ACUPB5000
6ACUPC6000
7ACUPD7000
8ACUPE8000
9ACUPF9000
Sheet1

In Sheet2
Book1
ABCDEF
1QTYOrOr
2ACUPX2200010001000
3ACUPY81600020002000
4ACUPZ51500030003000
Sheet2
Cell Formulas
RangeFormula
D2:D4D2=C2*IFERROR(VLOOKUP(B2,Sheet1!$A$1:$B$9,2,FALSE),"")
E2:E4E2=IFERROR(VLOOKUP(B2,Sheet1!$A$1:$B$9,2,FALSE),"")
F2:F4F2=IF(B2="ACUPX",1000,IF(B2="ACUPY",2000,IF(B2="ACUPZ",3000)))
 
Solution

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,316
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,369
Messages
5,601,223
Members
414,434
Latest member
Riyen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top