+ Reply to Thread
Results 1 to 2 of 2

Index Match Match for pricing matrix not working

  1. #1
    Registered User
    Join Date
    06-11-2018
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    2

    Question Index Match Match for pricing matrix not working

    Hi All,

    I am just doing an Index Match Match for a pricing matrix and I can't get it to work as intended.

    The matrix is just compares length by width to get a price. When I put a dimension in lower than my smallest size all I get is NA and when put in a size larger than my biggest allowable size it still comes up with a price.

    The formula is as follows: =INDEX(B5:C18,MATCH(A2,A5:A18,1),MATCH(B2,B4:C4,1))

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,459

    Re: Index Match Match for pricing matrix not working

    So you wish to get the minimum width is 250 and lenght is 3600 ?
    Please Login or Register  to view this content.
    Quang PT

+ 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. [SOLVED] Vlookup or Index with match to add pricing
    By DAVIDJMORIN in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-16-2019, 04:18 PM
  2. Index and Match Pricing Dilemma
    By dbsbender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-31-2019, 11:15 PM
  3. [SOLVED] Calculating invoice price from pricing matrix using INDEX/MATCH
    By UKPatriot1980 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-21-2017, 10:18 AM
  4. Index/match pricing formula
    By Nathan 135 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-12-2016, 12:48 PM
  5. [SOLVED] Working INDEX MATCH with SEARCH, but I need to add another MATCH to the formula!
    By DaveBre in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-11-2014, 01:03 AM
  6. Replies: 2
    Last Post: 05-24-2013, 09:32 AM
  7. Moving Data with Index & Match for Pricing Sheet
    By Cameron12 in forum Excel General
    Replies: 9
    Last Post: 07-25-2012, 07:23 PM

Tags for this Thread

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