Match with A and B with different type of pattern

Hi

I have list of excel formula for matching A and B column.

the same formula required in Macro.

First Name Last Name Email pattern Excel fourmula Result
Abhishek Garg abhishek.garg =LOWER(A2&"."&B2) TRUE
Abhishek Garg a.garg =LOWER(LEFT(A2,1))&"."&LOWER(B2) TRUE
Abhishek Garg agarg =LOWER(LEFT(A2,1))&LOWER(B2) TRUE
Abhishek Garg abhishek =LOWER(A2) TRUE
Abhishek Garg garg =LOWER(B2) TRUE
Abhishek Garg gabhishek =LOWER(LEFT(B2,1))&LOWER(A2) TRUE
Abhishek Garg abhishek_garg =LOWER(A2)&"_"&LOWER(B2) TRUE
Abhishek Garg abhishekg =LOWER(A2)&LOWER(LEFT(B2,1)) TRUE
Abhishek Garg a_garg =LOWER(LEFT(A2,1))&"_"&LOWER(B2) TRUE
Abhishek Garg garg.a =LOWER(B2)&"."&LOWER(LEFT(A2,1)) TRUE
Abhishek Garg garg_a =LOWER(B2)&"_"&LOWER(LEFT(A2,1)) TRUE
Abhishek Garg garga =LOWER(B2)&LOWER(LEFT(A2,1)) TRUE
Abhishek Garg abhishekgarg =LOWER(A2)&LOWER(B2) TRUE
Abhishek Garg gargabhishek =LOWER(B2)&LOWER(A2) TRUE
Abhishek Garg garg_abhishek =LOWER(B2&"_"&2) TRUE

Thanks
Josh

pls. find the format of formula in the attached excel

UDF
Use in cell like
=Match2Cells(A2,B2,C2)

Please Login or Register  to view this content.

Hi jindon,
thank you for above code
i have new more pattern to add.( middle name)
please can you add code for the same in the above code it self.
find the attached file

thank you once again.

=Match2Cells(A2,B2,C2,D2)

Please Login or Register  to view this content.

hi jindon,
thank you for sharing knowledge, all the pattern are showing true,
except

Abhishek Garg garg '=LOWER(B2) TRUE

please do the modification on the code.

thank you very much

Please Login or Register  to view this content.

hi Jindon,
please teach me that, how add pattern in this.

ex. what is the code for below pattern

=LOWER(A2&"-"&B2&"-"&C2)

thank you for teaching in advance

regards
josh

hi jindon

thank you for your reply.

Please find the attachment false result

regards
josh

Please Login or Register  to view this content.

thank you Jindon,
its matching to all. if i have still more pattern's how can i add in this code.

any input on this to learn

Thanks & regards
Josh

Google Regular expression.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED

hi jindon
thank you very much

hi Jindon,
i have one few more pattern need to check can you help me

thanks
josh

What is it?

hi Jindon

thank you for replay. i hope you are doing good.


the priveous code is very use full for me.

my resuqest is which ever the true value is shows, that fourmula as to display in the next column.
based on that, i want to create pattern for other set of records.

please find the attached sample excel file

thank you in advance.

regards
Josh

Do you mean

Please Login or Register  to view this content.

?

Hi Jindon,
i need to create pattern for some set of records, based on excising pattern, so, i have attached one more sample to better convey to you of my requirement.

please help me to work done.

Thank you

Attach a workbook with current code that you are using.

Yes Jindon,

based on that only, am working.

if i got the solution for creating true value pattern, my manual work will be reduced 50%.

thank you.
josh

Hi Jindon,

any update for my request.

thanks in advance

Originally Posted by jindon

Attach a workbook with current code that you are using.

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

hi Jindon,
i have one few more pattern need to check can you help me
please check the attachment.

thanks
josh

hi Jindon,
let me know its possible to do with macro,
i hope you can do this.

thank you in advance

regards
Josh

You are making it too complex and matching to almost any.

I suggest you to go to CS Forum.