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, Book1.xlsxBook1.xlsx

[AliGW]

OK - you need to set up a lookup table somewhere in your workbook - all product codes and their prices. You can then use a VLOOKUP formula to bring the correct value across from the lookup list.

https://exceljet.net/excel-functions...ookup-function

[AliGW]

Cross-posted: https://www.mrexcel.com/board/thread...-cell.1159379/

Read this, please: https://www.excelguru.ca/forums/faq....osting_details