I need a formula or VBA Code to put column a into column c if certain text matches. Example included.

[ExcelBean]

Column A is not in the proper order. It has URLs that I need to put into column C according to the order of column B. Column B also has a portion of the URL that would be an exact match. Example: Somewhere In column A: https://www.wheelchairparts.com/store/pc/Aluminum-Hip-Thigh-Trunk-Support-Bracket-Straight-p999.htm Somewhere In column B: Aluminum-Hip-Thigh-Trunk-Support-Bracket-Straight I need column B to stay in order, so put the match in column C. URL could also look like: https://www.wheelchairparts.com/sto...ength-Armrest-6-7-8-Hole-Spacing-Black-p9.htm and in column B: Padded-Quickie-Full-Length-Armrest-6-7-8-Hole-Spacing-Black

 

[MountainFog]

Paste in Column C

=IF(ISNUMBER(SEARCH(B1,A1)),A1,"")

 

[Scott Huish]

What version of Excel do you have? If 365 then perhaps:
=FILTER(A:A,ISNUMBER(SEARCH(B1,A:A)))

 

[ExcelBean]

Thank you so very much. You have helped me 301 redirect my entire website and saved a hundred hours.