How can I find next small value(look up value) in a range?

[mana]

Worksheetfunction.small(rng, 2)

https://msdn.microsoft.com/en-us/vba...or=-2147217396