+ Reply to Thread
Results 1 to 3 of 3

Pricing Lookup based on qty bought

  1. #1
    Registered User
    Join Date
    02-17-2010
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    45

    Pricing Lookup based on qty bought

    Hello,

    Please see the attached spread sheet. Basically I need S21 to lookup the price based on S17 and S18. Any help is most appreciated! Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Pricing Lookup based on qty bought

    change j13:m13 to 1,5,10,15,20
    then use in s20
    =INDEX(J15:N22,MATCH(S17,A15:A22,0),MATCH(S18,J13:N13,1))
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    02-17-2010
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Pricing Lookup based on qty bought

    Perfec!! Thank you Martin!

+ 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