Results 1 to 7 of 7

Need to find the largest value less than (not equal) to a lookup value using Index-match

Threaded View

  1. #1
    Registered User
    Join Date
    12-19-2015
    Location
    Turkey
    MS-Off Ver
    2010
    Posts
    6

    Need to find the largest value less than (not equal) to a lookup value using Index-match

    Hi dear all

    Need to find the largest value less than (not equal) to a lookup value from a table using Index-match (refer to attachment). As you see my formula in the cell H6 is


    =INDEX(E5:F15,MATCH(H5,E5:E15,1),1)


    and my Lookup value is the the value on cell H5 but when I select the match type value '1' it gaves me the value equal to my lookup value. is there any way to get only the smaller value than the lookup value?
    any help is appreciated. tanx in advance
    Attached Files Attached Files
    Last edited by Farahmand; 12-19-2015 at 10:09 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 04-04-2015, 04:24 AM
  2. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  3. Replies: 2
    Last Post: 04-28-2013, 05:55 PM
  4. Replies: 3
    Last Post: 07-11-2009, 02:58 PM
  5. Replies: 2
    Last Post: 07-02-2006, 05:50 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