Using VBA to search for a string (fuzzy logic)

Please use code tags when posting. I don't see any attachment.

hi JOHN H. DAVIS
I have re-attached file

And i dont know how to code tag

See Forum Rule No. 3 for the code Tag Rule. 217 Posts and no one ever mention code tags to you before?

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

Please Login or Register  to view this content.

... and appear like this when posted:

[Select Code] copy to clipboard

your code here ...
and here ...
and here

You can also type the code tags in manually if you prefer. For more information about these and other tags, click here.

HI John H. Davis

Thank you for the heads up
Hopefully my post now complies with the forum guidelines :P

Not the best way but Maybe:

Please Login or Register  to view this content.

Hi JOHN H. DAVIS

thank you for providing some logic
HOw can i apply the logic for all of column A & B instead of certain rows ?

For eg the look up currently looking at values C3 - C6

Another option

Maybe:

Please Login or Register  to view this content.

HI Ab33 and John H.Davis

Thank you for your solutions

I have a situation when i have "Eastern BMW & MINI" in column A, but i know there is a company called "Eastern BMW" in column B, but in both your examples, column A is not being highlighted, any ideas ?

Regards
D

Is this how you wanted?

Please Login or Register  to view this content.

Ditto Post #12.

Hmm

Thanks for the heads up your help is truly appreciated
Regards
D

Did you try Jindon's code?

................