Hello Team,
Need your help in doing pattern matching. I have data on two sheets.
I have to match a column from two sheets and get the corresponding values when the pattern matches
Sheet 1 Second.PNG and Sheet2 First.PNG
As per the screen shot, I have column called section name on Sheet 1 and Name on Sheet 2.
Example: Name "Agentporta" will be appended by random numbers in the front and back of the name like "sec02552Agenportaportno"
I have compare and if the name matches, I have get the corresponding ticket no from Sheet 2 and paste it into Sheet 1.
I am confused in matching here... please help
Bookmarks