Use Vlookup to return minimu values when the are multiple minimum values in a range

I am struggling with and request suggestions or help with a lookup or array formula that will return the minimum or smallest values from a range where the minimum or smallest values are not unique. I’ve attached a sample worksheet to help illustrate.

Refer to table 1 in the attached sample. When all values in the table (from B5:C14) are unique, I am able to write a lookup formula that returns both the lowest score as well as the player name using the Vlookup and Small functions that will display the results in cells G6 and G7.

In Table 2, there are two scores that are equivalent and meet the test of the minimum value, therefore my Vlookup formula is unable to identify there are two minimum values in the range. Perhaps it Is at this point that I need to implement usage of the Index function or some other technique. In addition, I want a formula in both cells F21 and F22 that would display the text “1st Place Tie” when multiple minimum values are present.

Of course, there may be a situation when the table contain a unique minimum value but there are two next to lowest values in the range. In this case, I would want a formula to display the lowest minimum score along with the player name plus a label that reads “1st Place” and then a formula on the next two rows to identify the next to lowest values separately as depicted in Table 3 of the sample.

Score Board Example.xlsx Any thoughts or suggestions would be appreciated.

Hi,

See the file. But I hope you want to display only 1st & 2nd Place or 1st Tie only.

Thanks for your reply. In this case, I am only concerned about identifying 1st or 2nd place or any 1st or 2nd place ties. I see how your formulas work in cells G22 and H22 which is perfect in event there are two scores that are the lowest in the range. I will attempt to adapt your formulas to account for situations where there is a unique minimum in the range and two or more next lowest minimums in the range so that ties for second place may be identified.

HI,
are you trying to pull out only the The first & second & tie for these places only ?

Punnam

That is correct as I only need to identify first and second place as follows: Unique First place and unique second place, or multiple ties for first place and a unique second place, or unique first place and multiple second place.

Thank you nflsales. I will review. I failed to mention a 4th possibility which would be multiple ties for1st and multiple ties for 2nd. I will also check your formulas for this outcome.

@ Siva,

Really impressive

Punnam

Excel 2007

Thank you and to all for your help. I will review your updates and follow up in a few hours.