Find nearest match in range

[Un-Do Re-Do]

I'm using this macro to try and find the row which matches 3 criteria.
In the example given, in Column A and B there is an exact match available. In Column C, there is no exact match and a "closest" match is required.
By "closest" I mean, the next option alphabetically.

Is there a function similar to "WorksheetFunction.Match" which would do this?
Or is something required to compare strings character by character?


Untitled.png

Please Login or Register  to view this content.

[6StringJazzer]

WorksheetFunction.Match will indeed do this. Use a third argument of 1 instead of 0. But your data has to be sorted alphabetically.

If your data is not sorted, then you will have to write the matching logic yourself.

[Un-Do Re-Do]

Yes you're right. Thanks for that.

[6StringJazzer]

No worries, and thanks for the rep!