Results 1 to 3 of 3

Thread: depended drop down

  1. #1
    Neophyte capofarukgb's Avatar
    Join Date
    Dec 2018
    Posts
    2
    Articles
    0
    Excel Version
    2010

    depended drop down



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

    so I'm trying to do a quotation based on depended drop down
    I have two colums 1 description 2 price
    trying to achieve is
    when I select number 1 colum I want number 2 to be automatically displayed
    can any one help ?

    Sent from my SM-N950F using Tapatalk

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,499
    Articles
    0
    Excel Version
    Excel 2016
    I think you are looking for a Vlookup...

    I am assuming that you have the descriptions and respective prices in your Price List sheet?

    If so, then try something like:

    =IF(A17="","",Vlookup(A17,'Price List'!A:B,2,0))


    where your price list is in columns A-B of "Price List" sheet,

    Then you can copy formula down.


  3. #3
    Neophyte capofarukgb's Avatar
    Join Date
    Dec 2018
    Posts
    2
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by NBVC View Post
    I think you are looking for a Vlookup...

    I am assuming that you have the descriptions and respective prices in your Price List sheet?

    If so, then try something like:

    =IF(A17="","",Vlookup(A17,'Price List'!A:B,2,0))


    where your price list is in columns A-B of "Price List" sheet,

    Then you can copy formula down.
    you are absolute legend that worked thanks

    Sent from my SM-N950F using Tapatalk

Posting Permissions

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