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