Changing cell number automatically according to another cell

[FONT=&quot]Good morning,[/FONT]

[FONT=&quot]Please I need help in this excel sheet. (attached)[/FONT]

[FONT=&quot]In Colomn B, I have mentioned 3 products.[/FONT]

[FONT=&quot]Each one has a price:[/FONT]

[FONT=&quot]ACUPX: 1000[/FONT]
[FONT=&quot]ACUPY: 2000[/FONT]
[FONT=&quot]ACUPZ: 3000[/FONT]

[FONT=&quot]What I need is that the prices change automatically in Column D if we change the product mentioned in column B.[/FONT]

[FONT=&quot]For example: if we change in column B4 ACUPZ to ACUPY the price change from 3000 to 2000.[/FONT]


[FONT=&quot]Thanks for help, [/FONT][FONT=&quot]

View attachment Book1.xlsxView attachment Book1.xlsx[/FONT]

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/excel-vlookup-function

Cross-posted: https://www.mrexcel.com/board/threa...omatically-according-to-another-cell.1159379/

Read this, please: https://www.excelguru.ca/forums/faq.php?faq=crossposting#faq_crossposting_details