+ Reply to Thread
Results 1 to 3 of 3

IF Functions with Small and Large Functions? Not Sure

  1. #1
    Registered User
    Join Date
    03-02-2016
    Location
    Illinios
    MS-Off Ver
    2013
    Posts
    3

    IF Functions with Small and Large Functions? Not Sure

    I've attached the document with comments describing what I need Excel to do. Please help me because I'M LOSING MY FREAKING MIND. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: IF Functions with Small and Large Functions? Not Sure

    This in T3 and dragged across will work

    It doesn't need to be this complex if the titles are always in the same order BUT this will ensure that if the orders are changed the formula should still work

    =INDEX($H$3:$M$3,MATCH(INDEX($A$1:$F$1,MATCH(O3,$A$3:$F$3,0)),$H$1:$M$1,0))
    Happy with my advice? Click on the * reputation button below

  3. #3
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: IF Functions with Small and Large Functions? Not Sure

    Thanks for the rep points. I gather this is closed so could you mark it as solved ? Thanks

+ 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] Large & Small Functions Not Working If A Column Has Multiples Of The Same Date
    By Philb1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-26-2015, 07:03 PM
  2. SMALL/LARGE functions...
    By rachandsouza in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2015, 06:33 AM
  3. Functions similar to SMALL or overcome limitations of SMALL
    By arvindtechie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2013, 10:59 AM
  4. [SOLVED] if+small functions question
    By Alexander_Golinsky in forum Excel General
    Replies: 2
    Last Post: 06-26-2012, 11:34 AM
  5. SMALL/LARGE Functions & Identical Values Issue
    By an_otter in forum Excel General
    Replies: 5
    Last Post: 03-15-2011, 06:29 PM
  6. Attaching labels when using large or small functions
    By BobT in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2005, 07:06 PM

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