Results 1 to 9 of 9

Index and Match where one of the lookups needs to be nearest to

Threaded View

  1. #1
    Registered User
    Join Date
    08-21-2014
    Location
    sdsd
    MS-Off Ver
    0007
    Posts
    5

    Index and Match where one of the lookups needs to be nearest to

    I have a index and match function trying to lookup a MF in a table using multiple match criteria. The problem is that one of the criteria to look up- the rate - is not going to match the table so i need to have it find the nearest one. Can someone look at the attached sheet and see if they can figure this one out???

    =INDEX(G12:M25,MATCH(1,(L12:L25=C11)*(M12:M25=C7)*(H12:H25=C9),0),3)

    Using this formula in C18 as the lookup. C9 needs to find the nearest in Column H

    help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multiple criteria lookups (INDEX + MATCH?)
    By exceldummy1990 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 08-12-2014, 07:20 AM
  2. Index Match formula for multiple lookups
    By RequestGuruHelp in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-04-2013, 10:51 PM
  3. [SOLVED] Help with INDEX MATCH embeded functions with 2 way lookups
    By trai4244 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-13-2012, 05:21 PM
  4. INDEX and MATCH with range LOOKUPs?
    By neilbomb in forum Excel General
    Replies: 9
    Last Post: 06-22-2010, 07:33 PM
  5. Lookups Match Index??
    By myheadhurts in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2008, 03:27 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