VLOOKUP Closest Match Not Close Enough

Hi,

Can someone please tell me how i use the below code.

I am new to this, so I have no idea

Thanks

Panic

Originally Posted by bestresearch

Vlookup does a poor job with non-exact text matches.

Prior posts do a great job of finding exact text matches, but I decided to write one with closest text match.

Note, the optional range_lookup paramater does not do anything. Perhaps will implement that in the future to require exact match.

Works on my machine, but usual caveat of no guarantees...

Please Login or Register  to view this content.