+ Reply to Thread
Results 1 to 2 of 2

Return the next highest value when an EXACT MATCH is not found

  1. #1
    Registered User
    Join Date
    11-06-2013
    Location
    Bedfordshire, United Kingdom
    MS-Off Ver
    Excel 2012
    Posts
    4

    Return the next highest value when an EXACT MATCH is not found

    Hi Guys

    I am trying to locate the next value higher as in if my INDEX cannot find an exact MATCH then return the next highest value.
    something like here, but it doesn't work for me.

    https://www.dropbox.com/s/yhsth5291a...4592.xlsx?dl=0
    Last edited by martinl; 09-07-2016 at 06:55 AM.

  2. #2
    Registered User
    Join Date
    11-06-2013
    Location
    Bedfordshire, United Kingdom
    MS-Off Ver
    Excel 2012
    Posts
    4

    Re: Return the next highest value when an EXACT MATCH is not found

    OK solved but not as I thought
    A bit outside of the box but attached is my solution

    https://www.dropbox.com/s/yhsth5291a...4592.xlsx?dl=0

+ 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] Found function with exact match
    By bimo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2014, 04:27 AM
  2. VLOOKUP when an exact match is not found
    By toemoss in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-06-2014, 06:01 PM
  3. [SOLVED] Return blank if no exact match or blank is found
    By matrixpom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 12:57 AM
  4. Replies: 3
    Last Post: 04-25-2007, 08:27 AM
  5. Replies: 0
    Last Post: 08-25-2005, 03:46 AM
  6. [SOLVED] Lookups-an exact match is not found
    By Mike O'Donnell, Columbia MD in forum Excel General
    Replies: 1
    Last Post: 05-13-2005, 10:06 PM
  7. [SOLVED] Lookup returns message box when an exact match is not found
    By JFeeman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2005, 04: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