It took me a long time to get this working on Excel, and just as I managed to do it, my company changed over to Google Sheets!
I work for a packaging company, and we sell hundreds of different boxes in different sizes and shapes. On a daily basis, we receive requests from customers giving there required box dimensions, and we have to go through all the products, checking the dimensions, to find the closest match.
I created a spreadsheet on Excel whereby I can insert the customers' required Height in one cell, required Depth in the next cell and required Length in the next cell, and it will perform a search which would bring back the product code with the closest corresponding dimensions. On Excel, this was achieved using the formula:
Column A = Product Column B = Width Column C = Depth Column D = Height H2 = Where I would insert customers required Width I2 = Where I would insert customers required Depth J2 = Where I would insert customers required Height
The formula is located in L2.
Unfortunately Google Sheets does not recognise the AGGREGATE formula! I have attached a screen shot of how it is set up on Excel, with the formula shown in the bar relating to L2.