Hi,

Is there a way/formula to create a vlookup for non-exact match. As we know vlookup only returns a value for exact matches. Is it possible to create one that will still return a value although the match is only at 70%?

This is needed for name format that occasionally changes. i.e.

1st entry: John A. Doe
2nd entry: Doe, John
3rd entry: Doe, John A.