Results 1 to 8 of 8

Can't find corrext Index Match formula where different options have same sub-options

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365 Version 2501 64-bit
    Posts
    1,465

    Can't find corrext Index Match formula where different options have same sub-options

    As shown on the attached, pricing list has four criteria, three (Supplier, Product Types and Finishes) are in columns, and the Size is in rows.

    Challenge is that each Product Type has the same two choices for Finish.

    Currently calculating the correct price by "nesting ifs" matching every permutation of Supplier, Type, Finish and Size to each column of prices.

    I know this can be done by one overall Index/Match, but just can't work out the correct structure!

    Hope someone can see the wood for the trees.

    Any suggestions, pointers and solutions are welcome as ever.

    Ochimus
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 08-26-2014, 08:44 AM
  2. extracting text string with 2 options @ end & limited options
    By ChristianR in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-24-2010, 06:51 AM
  3. Replies: 1
    Last Post: 08-11-2006, 12:00 PM
  4. [SOLVED] Working with options from within Tools Options clears the Clipboar
    By Peter Rooney in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-18-2005, 12:55 PM
  5. How to diasble the 'Tools - Options - View - Comments' options?
    By Alan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2005, 07:06 PM
  6. How to set options for Auto Fill Options?
    By aijihz in forum Excel General
    Replies: 1
    Last Post: 03-28-2005, 01:24 AM

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