search strings

  1. D

    String "TEMAN" is not recognized in namedrange for SEARCH command?

    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...
  2. G

    HELP with search in strings

    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/...
  3. T

    Search entire row for string

    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...
  4. K

    Need to return multiple values based upon multiple criteria

    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...
    • klop
    • Thread
    • lookup multiple criteria lookup multiple values search strings
    • Replies: 3
    • Forum: Excel Questions
  5. A

    macro to search with two criteria

    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...
    • auber
    • Thread
    • find value multiconditional search strings userform
    • Replies: 2
    • Forum: Excel Questions
  6. J

    Elegant Solution for Searching for Multiple Strings in Multiple Cells using NAME?

    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...
  7. C

    Search a string within a sheet

    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.
  8. I

    Create new data column from 2 different word lists

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top