fuzzy lookup without addin

[tonyjyoo]

Is it possible to write formulas to perform a "fuzzy lookup" without installing the addin?

E.g. I have 2 columns with partial matches in the middle of each description, but varying numbers and texts before and after.

 

[starl]

you could try the FIND function, which will return the starting position of a word/character.
So, for example, if in A1 I have "Is this a test" and in B1 I put =FIND(" a ",A1,1), it will return 8

 

[tonyjyoo]

you could try the FIND function, which will return the starting position of a word/character.
So, for example, if in A1 I have "Is this a test" and in B1 I put =FIND(" a ",A1,1), it will return 8

Not every cell will be the same though. Such as searching for "a" in your example.

 

[Joe4]

Triplicate:
Vlookup partial text
http://www.mrexcel.com/forum/excel-questions/968475-partial-matching-vlookup.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).