Results 1 to 10 of 10

Index & Match for multiple Column and Row to find header...

Threaded View

  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    11

    Index & Match for multiple Column and Row to find header...

    Hi all, this is my first post and can usually bodge a formula together from posts on this forum but can't get it this time.

    What I am trying to get is the minimum crane name based on three minimum criteria.
    1. In 'C10' I can get the minimum row number.
    2. In 'D10' I can get the minimum column number.
    3. In 'E10' I can cross reference the two to get the maximum lift of that selection.
    4. In 'F10' you can see that that crane cannot lift the load i need so it fails, what it need to do is look to the left of the row until it finds a column with a value greater that the lift.
    5. In 'C14' I can't get that final row/column reference needed in 'F10' to then get the crane name listed in 'K6:T6'

    Hope some of this makes sense and all help is greatly appreciated.
    C
    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. [SOLVED] OFFSET+ INDEX-MATCH to find first non-zero column
    By Ztv in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-04-2014, 01:51 PM
  2. How do i find the max of two values from index match max of a column
    By mohaymin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2013, 02:04 PM
  3. [SOLVED] Index and Match Multiple Header (Rows) Criteria
    By dluhut in forum Excel General
    Replies: 7
    Last Post: 04-12-2012, 06:25 PM
  4. Return Column Header from Index/Match function
    By del24ie in forum Excel General
    Replies: 2
    Last Post: 01-12-2012, 11:57 AM
  5. Index/Match Function to Return column header
    By djmarsh51 in forum Excel General
    Replies: 2
    Last Post: 05-07-2010, 02:10 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