Need Help with Vlookup and Index Functions to Solve for Error

I need help with a formula using a combination of vlookup and index functions that solves for empty cell in the range I need to index. In the attached workbook, Example A displays a range from B7 to D12 that I need to use the vlookup/index formula beginning in F7 to find the lowest value (range D7:d12) and sort that range from lowest to highest value. Cells beginning in G7 and H7 apply the same technique but index for different values.

My issue is that when I expand the range and which includes blank cells (Example B) and using the same formulas, the formula returns an error in F7. I assume this is because the formula in F7 does not consider how to treat blank cells in the range I’m seeking to index.

Please suggest modifications to the formulas in F7, G7, and H7 to can accommodate empty cells in the range I am attempting to index. I've attached a sample workbook below. Thanks!Vlookup and Index Sample.xlsx

NDM, thank you! this is a much more efficient manner to get the sort task accomplished. However, if one of the rows in the range D7:D12 is blank, then the formula returns a #NUM! error. In addition of one of the cells in column B or C is blank the corresponding formulas return a zero. I would like the forumula to be able to disregard blank cells within the range and only sort and return what is entered. Thoughts?

Thanks. I will take a look and follow up.

Everything looks great except for the display beginning in K16 on your sample. Rather than displaying the rank in column K for each value, I would like the original number from column D displayed (in this case 15). Also, I failed to specify earlier that the rank order arguement for Column D would be from lowest to highest. I'm not sure how to change the order arguement in the Helper column.

Okay, this looks like it will do the job. Can't thank you enough for your help!

Newdoverman (or anyone),

I have applied your solution (in the lower portion of this thread) for ranking results using the Index/Match functions to a different situation. I have attached a sample spreadsheet that includes the requisite formulas and helper columns. The issue is that the results of the ranking do not appear to consider when there are two or more values that are the same. I’ve highlighted the occurrences in the sample spreadsheet (specifically for players 12 and 15) where I would have expected the ranking results to display player 17 (to display as tied with player 12) and player 19 (to display as tied with player 15).

Would you please take a look and advise on the adjustments to the formulas that are required?

Thank you for your reply, explanation and fix. It solved the problem. I will pay closer attention next time, but you did help get out of a jam here. Thanks agains.