Return Row Title based on critera

[restyl1997]

Hello!

I've found much valuable information on this forum, however I am having a hard time applying some examples I've found to accomplish my goal in this particular scenario.

I have a table that uses data validation lists made from data on different sheets. In other words, the values generated from user-input in cells A2 (208V) & B4 (558.4), should refer to sheet "ABB Disconnects" & return the appropriately sized disconnect to cell B6. Here is the user-inputted data sheet "Disconnect Sizer":
Sizer.png

Here is sheet "ABB Disconnects" with the sizing data:
Disc.png

In the scenario shown in the first image, 208V & 558.4 (amps), the "OT200" row title should be returned to cell B6 because 962 is the closest greater value to 558.4.
Final.png


Notes:
RED is for user-input sheet "Disconnect Sizer"
ORANGE is for data sheet "ABB Disconnects"

[AlphaFrog]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[CK76]

If you can sort "ABB Disconnects" based on any value column -> Largest to smallest.

You can use following:
=INDEX('ABB Disconnects'!A3:A6,MATCH(B4,INDEX('ABB Disconnects'!B3:F6,,MATCH(A1,'ABB Disconnects'!B2:F2,0)),-1))

[restyl1997]

Thank you for a step in the right direction, CK76. I changed cell A1 to A2 (Voltage Value) in your function and gave it a go, but get N/A returned. See attached
Much appreciated.

[CK76]

Note this part.

sort "ABB Disconnects" based on any value column -> Largest to smallest

See attached.

[restyl1997]

Thank you very much for your solution CK76. I noticed your comment after hitting that reply button and began editing my comment :P

You're an Excel hero!

[CK76]

You are welcome and thanks for the rep