Results 1 to 3 of 3

Thread: Changing cell number automatically according to another cell

  1. #1
    Neophyte Rami100's Avatar
    Join Date
    Jan 2021
    Location
    Lebanon
    Posts
    1
    Articles
    0
    Excel Version
    2016

    Changing cell number automatically according to another cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,606
    Articles
    0
    Excel Version
    Office 365 Subscription
    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
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,606
    Articles
    0
    Excel Version
    Office 365 Subscription
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •