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
Bookmarks