+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Index and Match-prices and catalog numbers

  1. #1
    Registered User
    Join Date
    06-15-2010
    Location
    Kansas
    MS-Off Ver
    Excel 2003
    Posts
    60

    Index and Match-prices and catalog numbers

    I have a spreadsheet I am going to attach that. Under the Entry form. I have prices and catalog numbers and quantity. Under my Proposal tab. I have the form for somebody to fill out. I need two options to be true in order for the price to come up. So if you buy 500 instead of 250 you get a price break. The problem is it works under one of the matches but not both. My formula is

    Please Login or Register  to view this content.
    Thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-15-2010
    Location
    Kansas
    MS-Off Ver
    Excel 2003
    Posts
    60

    Re: Help with Index and Match

    anybody.. help.. or a i differnet way to do it lol

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    re: Index and Match-prices and catalog numbers

    Given the way you have configured your table and your use of merged cells:

    Please Login or Register  to view this content.

+ 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