+ Reply to Thread
Results 1 to 4 of 4

data validation & multiply values based on the choice

  1. #1
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    133

    data validation & multiply values based on the choice

    Hi

    ive got a spreadsheet and ive used data validation to look at a list on another tab.

    i need to be able to multiply values out based on what i choose on the drop down menu

    ive attached a sample spreadsheet to help explain

    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: data validation & multiply values based on the choice

    hello try this in c2
    =IF($A2="","",VLOOKUP($A2,Sheet2!$A$1:$B$5,2,0)*$B2)
    and drag down
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    133

    Re: data validation & multiply values based on the choice

    thanks hemesh, works a treat!

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: data validation & multiply values based on the choice

    Thanks for the feedback

+ 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. Replies: 4
    Last Post: 12-19-2013, 10:44 AM
  2. Replies: 3
    Last Post: 10-28-2013, 03:33 PM
  3. [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
  4. Perform action based on choice from validation list
    By kjetiltb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-05-2009, 04:57 AM
  5. Data Validation (Multiple Choice)
    By John Jost in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-13-2005, 09:50 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