Closed Thread
Results 1 to 2 of 2

Closest match with multiple criteria (3 criteria) Not matching perfectly!

  1. #1
    Forum Contributor JulianS96's Avatar
    Join Date
    11-01-2019
    Location
    England
    MS-Off Ver
    365 (work-99%), 2016 (home-1%)
    Posts
    266

    Closest match with multiple criteria (3 criteria) Not matching perfectly!

    Hello Excel forum!

    I previously posted a problem on trying to make a closest match formula with 3 different criteria work.

    That problem was fortunately solved..... until now!

    I am working on some box sizes and want the formula to automatically select the box with the closet match to the dimensions given of e.g. BOX "C1": 600x400x420 shuld be closely matched with a box of e.g. 600x410x325 and not a box of 600x411x350.
    My actual problem is that the formula is matching with a box of 601.98x401.32x320.04 rather than a box of 600x400x320.

    I will post the sample spreadsheet below with a mockup of the desired answer

    Thanks in advance,

    Julian
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Closest match with multiple criteria (3 criteria) Not matching perfectly!

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...-criteria.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Closest match with multiple criteria (3 criteria)
    By JulianS96 in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 02-03-2021, 03:12 AM
  2. [SOLVED] Match by multiple criteria and closest value
    By Benta1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2019, 04:53 AM
  3. Closest match based on multiple criteria
    By jeffs24 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-30-2017, 04:11 PM
  4. [SOLVED] Index Match 4 criteria perfectly, and not so perfectly
    By milkychips in forum Excel General
    Replies: 3
    Last Post: 01-26-2015, 01:16 AM
  5. [SOLVED] Closest match on Multiple Criteria
    By rbetts in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-20-2014, 08:33 AM
  6. Replies: 2
    Last Post: 12-04-2013, 01:01 PM
  7. closest match from multiple criteria
    By wongja in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2010, 01:37 AM

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