Results 1 to 5 of 5

INDEX/MATCH Array within LARGE Function?

Threaded View

  1. #1
    Registered User
    Join Date
    03-18-2015
    Location
    Little Rock, AR
    MS-Off Ver
    2010
    Posts
    10

    INDEX/MATCH Array within LARGE Function?

    I have been searching everywhere for something that might help me with this and I just cant seem to find it! I guess essentially I am trying to do a look up based on a column and then find the largest value from the row to the right of the data. It would look something like this,

    Data Sheet
    A 10 15 20 30
    B 8 16 32 64
    C 1 2 3 4
    D 2 4 6 8
    E 20 40 60 80


    Main Sheet
    Largest Value
    A 30
    B 64
    C 4
    D 8
    E 80

    The problem is I can make A,B,C,etc. static on my Main Sheet however since I am pulling data into the data sheet there is not always data for A,B,C,D,E which causes them to shift making it where I can just do a standard =Large(B1:B4,1).

    I've tried INDEX, MATCH, ROW and some other ideas but cant get anything to work!!!

    Any ideas? Thanks!
    Last edited by DZ217; 08-11-2015 at 04:15 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to: Return next value w/ same # in index match large function?
    By Yoshi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2015, 02:35 AM
  2. Index match with large function
    By morobo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2014, 02:27 PM
  3. [SOLVED] Variable Row Array in Index Match Function
    By Lacaycer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2013, 11:45 AM
  4. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  5. [SOLVED] Long array formula with INDEX and MATCH quits working when range is too large
    By UncleKevy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-05-2013, 09:42 PM
  6. Index, Match, Large Function returning duplicate names
    By RNeel55 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2013, 04:09 PM
  7. Using Index & Match with the Large function
    By JXH in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2011, 08:39 PM
  8. Index/Match function inside an array
    By tittiot in forum Excel General
    Replies: 2
    Last Post: 01-20-2010, 09:48 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