Results 1 to 5 of 5

Thread: If , vlookup and drop down list

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte IonutD's Avatar
    Join Date
    Mar 2020
    Posts
    2
    Articles
    0
    Excel Version
    2019

    Question If , vlookup and drop down list

    Hy there!

    I am trying to pull some data from another sheet, in my main sheet, in order to change some prices of produs, depending the type of them.
    In another sheet i put the products in one column, price for type1 in second column, price for type3 in third column, and price for type3 in fourth column.
    In the main sheet, I created a dropdown list to select the thype o products the customer whants, and I would like the prices to change when I change de selection in my dropdown list. I tried to write a function using vlookup and ifs, but I can't manage well this. Is there another way, maibe even VBA codes, to do this?

    Thanks and sry if this subject was before, I didn't find it.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,435
    Articles
    0
    Excel Version
    Office 365 Subscription
    Please attach a sample workbook, desensitised.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Neophyte IonutD's Avatar
    Join Date
    Mar 2020
    Posts
    2
    Articles
    0
    Excel Version
    2019
    Quote Originally Posted by AliGW View Post
    Please attach a sample workbook, desensitised.
    Formular ofertare demo.xlsm

    I attached the sample. Thx for interes!

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,435
    Articles
    0
    Excel Version
    Office 365 Subscription
    Sorry - I can't open your workbook as it's throwing up a potential security risk message. I won't risk it - I'm not prepared to.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Conjurer NormS's Avatar
    Join Date
    Jul 2017
    Posts
    119
    Articles
    0
    Excel Version
    Excel 2016 ProPlus
    Is this what you are trying to do? I've used INDEX/MATCH to do the equivalent of a VLOOKUP, along with INDIRECT to select the correct column in the price table.

    Norm
    Attached Files Attached Files

Posting Permissions

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