Match inputs in one column with data from another if >50% of their consec letters match

[TaskinRahman]

This is a smaller topic from my larger topic. I was wondering how I would create a macro or an if-statement to match an input in one column with the data located in another column as long as 50% or more of their consecutive letters match?

For example, if someone types in "oogle" instead of "google", I would want to still return google because more than 50% of the consecutive characters match.

So in procedural terms:

1.) Should I use the function len to count the number of all the characters in the cell and then store that somewhere?

2.) Then how would I go about seeing how many consecutive letters match? It could be that the first two don't match but then the rest of the letters do match?

Thanks in advance! Any and all help is appreciated.

[dilipandey]

Hi TaskinRahman,

I believe you are over thinking on this.. suggest you to use Search function which will give you the output and when to use this, if the "text to be searched" is more than 50% of Length of the "text in which to be searched" .. so ideally Search and Len / If function should work here.

Regards,
DILIPandey
<click on below * if this helps>