+ Reply to Thread
Results 1 to 6 of 6

Using a Vlookup based on Data Validation Choice

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    Covington, KY
    MS-Off Ver
    2010
    Posts
    4

    Using a Vlookup based on Data Validation Choice

    I'm working on a sheet that shows various discounts for products based on how much volume of product is purchased. I have a data validation box that lists the various amounts required (1 case, 2 case, etc.), and I have a sheet that has all the data (A1 is empty - column A is the case quantity - column B has a product name in B1 and then each discount based on the case quantity in Column A). I want the discount amount in Sheet 2 to fill in automatically based on the information on Sheet 1. Thanks for any help you can give me!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: Using a Vlookup based on Data Validation Choice

    this appears to be working (input in sheet2!b4 and filled down)
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    p.s. if you wanted to say thanks by sending some wine my way that would totally be acceptable.
    Hope I could help - if your post has been solved don't forget to mark it as such.

    Clicking the * below is a great way to say thanks!

    "Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito

  3. #3
    Registered User
    Join Date
    05-04-2015
    Location
    Covington, KY
    MS-Off Ver
    2010
    Posts
    4

    Re: Using a Vlookup based on Data Validation Choice

    Thanks for the help, although I may still be doing something wrong - attached is the sheet with the formula. I seem to lose the correct info return in B6, and the cells below that are not returning correctly.
    Attached Files Attached Files

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Using a Vlookup based on Data Validation Choice

    a small correction to simarui formula try the below on
    =INDEX(Sheet1!$A$1:$L$7,MATCH(B$3,Sheet1!$A$1:$A$7,0),MATCH(A4,Sheet1!$A$1:$L$1,0)) and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  5. #5
    Registered User
    Join Date
    05-04-2015
    Location
    Covington, KY
    MS-Off Ver
    2010
    Posts
    4

    Re: Using a Vlookup based on Data Validation Choice

    Thanks nfl! That worked!

  6. #6
    Registered User
    Join Date
    05-04-2015
    Location
    Covington, KY
    MS-Off Ver
    2010
    Posts
    4

    Re: Using a Vlookup based on Data Validation Choice

    Thanks again! (wine next time )

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Populate Cell Based on Data Validation Choice
    By Karen615 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2014, 02:34 PM
  2. Populate spreadsheet based on choice of data validation list
    By Thanks4helping in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2014, 08:38 PM
  3. [SOLVED] data validation & multiply values based on the choice
    By petelomax in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2014, 04:24 AM
  4. Replies: 3
    Last Post: 10-28-2013, 03:33 PM
  5. [SOLVED] Data validation - limit based on previous choice
    By Ricardo Mass in forum Excel General
    Replies: 8
    Last Post: 09-25-2013, 08:56 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1