Lookup with partial matches

[Rudi]

Hi,

See attached...
Is there a way to get a fair accuracy on these partial lookups?
The formula I have entered does not seem to work as accurately as i would have hoped...

[HansV]

I don't think it's possible to do this with the built-in functions. Try Microsoft's free Fuzzy Lookup Add-In for Excel. (I have no experience with it myself)

[Rudi]

Sorry Leif....my spelling must have been a bit fuzzy!

I actually did download and try it, but did not test through thoroughly as it's interface was a bit "sticky!"
I'll give it another go.

TX for the feedback.

[HansV]

You could use the fuzzy lookup functions from Fuzzy Matching - new version plus explanation on MrExcel.

I have attached a version using the FuzzyVLookup function from that post. Algorithm 2 works best here.

Fuzzy.xlsm

[Rudi]

Thank you Hans.
I have tested that formula out, but having re-evaluated the Add-In, it is providing a bit of a better result. I can use the add-in.

Appreciate the support as always.

[Rudi]

In retrospect, I may have spoken too fast...

I have been playing with the FuzzyVlookup and I like the flexibility it provides. I've been changing the paramenter values and modifying the NFpercent argument to control the matching...

TX.

[sdckapr]

There is some I wrote at http://windowssecrets.com/forums/showth ... not-exact-(Excel-97" onclick="window.open(this.href);return false;) which has 2 versions of a "nearmatch" UDF.

Steve

[Rudi]

Looks interesting.
Well worth experimenting with.

TX Steve.
Appreciate the contribution.