search strings

Hi Excel Experts, I came across very weird situation here. Hopefully, somebody can give me solution. I'm trying to create a formula that will search the string(s) in a namedrange and return "Yes" if one of them matches in the sentence of the referred cell and return "" if no match. However, I...

Hey all, I have URL strings such as: url/Live-to-Ride-Long-Sleeve-T-Shirt-5223/ url/Live-To-Ride-Motorcycle-Long-Sleeve-T-Shirt-4963/ url/Live-To-Ride-Motorcycle-T-Shirt-4964/ url/Live-To-Ride-Motorcycle-Women-T-Shirt-4965/ url/Live-To-Ride-Motorcycle-Women-T-Shirt-6096/...

I'm wanting to search two columns for the string in TextBoxSearchItemList.text. then put these values into another list position. as you can see here ive made a raw idea of what im trying to do but i think im trying the wrong method. any help would be appreciated. Ive tried to search for...

I'm not sure if Excel or Access is the best tool. I am seeking to search for roughly 1,000 unique search strings amongst 100,000 customers and identify all string matches. The customer data set consists of customer ID (column A) and customer name (column B). I would like to return all...

Hi friends, I have big problem, please help me. I am new in excel vba and I am learning. This is the problem: I have sheet like this: <TABLE class=MsoNormalTable style="MARGIN: auto auto auto 4.8pt; WIDTH: 145.5pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm...

Hi everyone - I currently have a working Excel Workbook that I am using to search multiple cells for an array of strings. I have condensed the strings in the array for purposes of posting on this site (there are dozens of strings to search for). Ideally, I'd like to put all the text in the...

Hello! Probably an easy one for you guys... I have a table of data and i need to search the table for 8digit numbers, that are beginning with "2" and copy the numbers to the column on the right. A cell can contain multiple numbers with 8 digits. Thanks in advance.

Hi, let's say I have data in columns A-B, and a target list in C: A B C dog 21 dog cat 43 mouse mouse 21 lion puppy 45 lion 23 What I need is a way to...