H, I have a table of forwarders and I just want to get the forwarder's name who has minimum charge or value of the short listed reference numbers, so I can get the heading name of the minimum value using this function =XLOOKUP(SMALL(B2:O2,1),B2:O2,B1:O1) but it's not followed by short listed reference number, I want get the heading name of the short listed reference numbers only. Is there any way to use vlookup or something to get the heading name of short listed reference number only. Please see the attached photo and help to solve it.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Getting the heading name of minimum value followed by reference numbers
- Thread starter Mohsin110
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 91,893
- Office Version
- 365
- Platform
- Windows
Duplicate to: Getting smallest value from a table followed by reference number
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
Upvote
0
- Status
