Results 1 to 9 of 9

Two-way lookup with INDEX and MATCH return closest match

Threaded View

  1. #3
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Two-way lookup with INDEX and MATCH return closest match

    Try this
    Formula: copy to clipboard
    =INDEX($C$4:$D$8,IFERROR(MATCH(25,$B$4:$B$8,0),1+MATCH(25,$B$4:$B$8,1)),MATCH(G4,$C$3:$D$3,0))

    where the values 1/2'' and 1'' are written with a single quote twice (code 039 not double quote code 112)
    See the file to clarification
    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] Index/match return value row1 and value column A closest > search value
    By 323428 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-25-2018, 03:15 PM
  2. Replies: 2
    Last Post: 12-18-2014, 09:52 AM
  3. Index&Match formula for closest match(s)
    By hom100 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-16-2014, 02:40 PM
  4. [SOLVED] Lookup temperature based on closest time using INDEX and MATCH
    By gshafiq in forum Excel General
    Replies: 7
    Last Post: 09-09-2014, 03:58 PM
  5. Match the Upper closest value using Index Match.
    By adnanaddo in forum Excel General
    Replies: 3
    Last Post: 01-16-2013, 02:47 AM
  6. LOOKUP to return closest match
    By Kateabc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2008, 12:56 PM
  7. lookup & return closest match
    By Joanie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2006, 10:46 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