Results 1 to 3 of 3

Adjusting pricing based on a X/Y axis

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Exclamation Adjusting pricing based on a X/Y axis

    For years I’ve been trying to complete this formula with no success, until I found this forum and hoping for some help.

    I’ve been trying to create a formula that pulls from columns and rows. We have pricing that’s based upon “quantity breaks” and the “amount of colors” were needing to use for the job. I would like to auto populate a price by entering these 2 factors in and having Excel lookup the appropriate price break.

    Attached is an example of the grid.
    For instance, if I wanted to print a 5 color design on 200 items, could I create a lookup code that pulls from that grid? is it possible for excel to handle that?

    Thanks!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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