Results 1 to 3 of 3

INDEX/MATCH Excel Question

Threaded View

  1. #3
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: INDEX/MATCH Excel Question

    hi and welcome to the forum

    may be in b2 use below
    copy paste below then hold control and shift together and then hit enter
    Formula: copy to clipboard
    =MIN(IF((A2='Tube Prices'!$A$2:$A$6)*(C2>='Tube Prices'!$B$2:$B$6)*(D2<='Tube Prices'!$C$2:$C$6),'Tube Prices'!$D$2:$D$6))


    array formulas are...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Last edited by hemesh; 02-17-2016 at 02:31 PM.
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. index match question
    By nawGo in forum Excel General
    Replies: 4
    Last Post: 01-30-2016, 08:54 PM
  2. [SOLVED] Index Match question
    By JO505 in forum Excel General
    Replies: 3
    Last Post: 10-20-2015, 03:16 AM
  3. Index match question
    By momiieee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2015, 05:54 PM
  4. Index, match, match Question!. Seems so simple but can't figure it out...
    By huikimhuikim in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2013, 01:57 PM
  5. Replies: 0
    Last Post: 11-04-2011, 01:53 AM
  6. [SOLVED] Index/match question.
    By Jules in forum Excel General
    Replies: 1
    Last Post: 07-08-2006, 11:10 AM
  7. [SOLVED] Index/Match question Need help!
    By Brian H in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-10-2005, 09:05 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