+ Reply to Thread
Results 1 to 3 of 3

Multiple Price Tiers for Excel Estimate.. HELP!

  1. #1
    Registered User
    Join Date
    02-18-2014
    Location
    Denver CO
    MS-Off Ver
    Excel 2010 MAC
    Posts
    1

    Multiple Price Tiers for Excel Estimate.. HELP!

    Hi there. I am trying to do something VERY simple but for the life of me cannot accomplish it.

    I create detailed manufacturing estimates in Excel to send out to customers. The estimate has about 200 line items on the "main" page, and there are 4 pricing tiers, depending on the type of customer we sell to: i.e. Tier 1, Tier 2, Tier 3 and Tier 4. Pricing for all 4 tiers is listed in a separate "work" sheet in the same document.

    I would like to add a drop-down menu on the "main" page (Tier 1, Tier 2, Tier 3 or Tier 4). When selecting a tier, the prices on the "main" page must automatically pull the corresponding price from the "work" sheet.

    A very basic example is attached. Please can someone assist? Many thanks.

    Example_justinrmjc.xlsx

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,256

    Re: Multiple Price Tiers for Excel Estimate.. HELP!

    Put in C4 (main page) and copied down

    =INDEX('WORK SHEET'!$B$8:$E$13,MATCH(A4,'WORK SHEET'!$A$8:$A$13,0),MATCH($C$2,'WORK SHEET'!$B$6:$E$6,0))

  3. #3
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,256

    Re: Multiple Price Tiers for Excel Estimate.. HELP!

    Check the file
    Attached Files Attached Files

+ 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: 3
    Last Post: 08-23-2013, 04:55 PM
  2. [SOLVED] Compare 1 price against multiple prices and change the price according to a formula
    By CharlieAziz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-16-2012, 11:05 AM
  3. Point Estimate
    By smallexcel in forum Excel General
    Replies: 1
    Last Post: 08-12-2012, 03:48 PM
  4. Multiple tiers, incremental percentages
    By Dougie12. in forum Excel General
    Replies: 8
    Last Post: 01-23-2012, 08:58 AM
  5. Finding point estimate and interval estimate
    By Codedzero in forum Excel General
    Replies: 1
    Last Post: 10-11-2009, 02:46 PM

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