How can I short values smallest to largest with below formula

[rajeshn_in]

I am using below formula from H3 to H8

=VLOOKUP($G3&"|"&$H$1&"|"&$J$1,$D$2:$E$19,2,0)

Drag down upto H8

I want all values short smallest to largest automatically

Please check attachment for better understanding.

[Glenn Kennedy]

Here's one way. Both are array formulae and will successfully split any tied results. You can also delete your helper column.

Array Formulae are a little different from ordinary formulae in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly brackets yourself - it won't work...

[rajeshn_in]

Excellent Glenn, Thank you, Can we add one condition in this formula....,

Please find attachment,

If C2 is equal to (or) greater than TODAY date, then we can use row data in I & J column.

[Glenn Kennedy]

I'll be back in about 1.5 hours.

[rajeshn_in]

ok, no problem, I can wait....

[Glenn Kennedy]

Back. As requested. I have also added an error-trap to tak account of situations (like this one) where there are fewer than 5 matching results.

[rajeshn_in]

Thank you very much Glenn

[Glenn Kennedy]

You're welcome & thanks for the Rep.