Results 1 to 7 of 7

Match and Find Matrix Values with Criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-02-2008
    Location
    Jacksonville Beach, Florida
    MS-Off Ver
    Microsoft Excel 2003 and 2010
    Posts
    264

    Smile Match and Find Matrix Values with Criteria

    Need a formula that searches a matrix, locates a range associated with two input values and then finds the nearst value to a third given input (eg 2.6) THAT is not higher than this value (2.6). "Black" and "cheese" in attached example correlate with the "range" values 1, 2, 3 and 12). The expected result would be 2 given the three inputs because 2 is the closest number to 2.6 that is not above 2.6…..help is MUCH APPRECIATED. Very important project here….
    Attached Files Attached Files
    Last edited by dreicer_Jarr; 04-06-2012 at 12:18 PM.
    ______________________________________
    "Vision without Execution is a Hallucination"
    Edison

Thread Information

Users Browsing this Thread

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

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