INDEX MATCH 3rd SMALLEST NUMBER

might be an idea to post a sample file with the various named ranges populated so we can see what it is you're returning and what you're referencing... I suspect you could probably use a LOOKUP approach with 4 viable outcomes listing in order of least preference... ie based on: no result, 3rd smallest result, 2nd smallest result, smallest result ... the LOOKUP if setup correctly will return the last valid output ... so if the smallest is found it will be returned, if not the 2nd smallest (if valid), else 3rd smallest etc etc until No Result at all.