+ Reply to Thread
Results 1 to 5 of 5

Returning unit price based on Qty from a customer price book with price qty breaks

  1. #1
    Forum Contributor
    Join Date
    02-14-2012
    Location
    Warrington
    MS-Off Ver
    Excel 2013
    Posts
    277

    Returning unit price based on Qty from a customer price book with price qty breaks

    Please Login or Register  to view this content.
    Anyone able to work out a formula for the highlighted column.

    Formula needs to look at the data table and match the
    • Customer
    • Product
    • Latest start validity
    • Qty ordered into the different price break quantities.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-14-2012
    Location
    Warrington
    MS-Off Ver
    Excel 2013
    Posts
    277

    Re: Returning unit price based on Qty from a customer price book with price qty breaks

    Bump, must have got you thinking

  3. #3
    Forum Contributor
    Join Date
    02-22-2011
    Location
    Rhône Alpes, France
    MS-Off Ver
    Excel 2007
    Posts
    201

    Re: Returning unit price based on Qty from a customer price book with price qty breaks

    Hi,
    A solution using Vlookup and if condition
    I'm not satisfied with this solution and I'm sure a guru will find a better solution
    Hope this help
    Best regards

  4. #4
    Forum Contributor
    Join Date
    02-14-2012
    Location
    Warrington
    MS-Off Ver
    Excel 2013
    Posts
    277

    Re: Returning unit price based on Qty from a customer price book with price qty breaks

    Quote Originally Posted by jpr73 View Post
    Hi,
    A solution using Vlookup and if condition
    I'm not satisfied with this solution and I'm sure a guru will find a better solution
    Hope this help
    Best regards
    Thanks, if only there was no manually typed criterias in the lookups then that would work.

    This is going to be applied to a 50,000 row pricebook so typing manual lookups wouldn't work unfortunately

  5. #5
    Forum Contributor
    Join Date
    02-14-2012
    Location
    Warrington
    MS-Off Ver
    Excel 2013
    Posts
    277

    Re: Returning unit price based on Qty from a customer price book with price qty breaks

    Anyone else able to help?

+ Reply to Thread

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