Results 1 to 11 of 11

INDEX MATCH as arrayfunction using MAX and PRODUCT

Threaded View

Sherk INDEX MATCH as arrayfunction... 10-06-2016, 05:10 AM
The_Snook Re: INDEX MATCH as... 10-06-2016, 05:30 AM
Sherk Re: INDEX MATCH as... 10-06-2016, 07:38 AM
xlnitwit Re: INDEX MATCH as... 10-06-2016, 07:46 AM
Sherk Re: INDEX MATCH as... 10-06-2016, 08:08 AM
The_Snook Re: INDEX MATCH as... 10-06-2016, 08:10 AM
Sherk Re: INDEX MATCH as... 10-06-2016, 08:15 AM
The_Snook Re: INDEX MATCH as... 10-06-2016, 08:28 AM
xlnitwit Re: INDEX MATCH as... 10-06-2016, 08:30 AM
Sherk Re: INDEX MATCH as... 10-06-2016, 08:48 AM
Phuocam Re: INDEX MATCH as... 10-06-2016, 08:41 AM
  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    17

    INDEX MATCH as arrayfunction using MAX and PRODUCT

    EDIT: I wrote MAX in the Heading incorrectly although the syntax should be the same I guess...

    Hello,

    I want to know which of the Y's that give the minimum value for the product between table 1 and 2. I.e. I want cell B2 to give me Y1, B3 to give me Y2, B4 to give me Y1 and B5 to give me Y3. My last try for a formula was
    =INDEX($H$1:$J$1;1;MATCH(MIN(IF($G$2:$G$5=$A2;$H$2:$J$5)*C2:E2);IF($G$2:$G$5=$A2;$H$2:$J$5)*C2:E2;0))
    .

    Please help!

    PrintScreen till ExcelForum.JPG
    Last edited by Sherk; 10-06-2016 at 08:48 AM. Reason: Heading is wrong MAX should be MIN

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Average value from month, year and product (index,match)
    By danwoltrs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-30-2016, 07:05 PM
  2. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  3. [SOLVED] Index match with min and sum product
    By lejanco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-16-2014, 01:01 PM
  4. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  5. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  6. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  7. match product id with product name from other workbook
    By mustangfanatic in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 07-22-2008, 03:37 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