Look for all matches in a sorted list. If no exact match is found all the nearest matches.
Been looking at lot of examples none I can adapt. Cheers Peter
e.g.
Col A/Col B
Tom 10
Bob 20
Mob 30
Yan 40
Den 40
Elf 50
Len 50
If my target is 40 I should have Ian 40 and den 40 should be listed.
If no...