search a cell

  1. S

    Find the text in the string and filter by word. Then copy the filtered content to a new sheet

    Hi Guys, (All EXCEL.LENT ladies and gentlemen) I have text in Column A. Here are the rows of the table that start with the following characters: <A1 ... For example: <A1 S = "20" D = "5.70" Z = "15.68" Date = "2021-03-25" F = "1000615" Abj = "DE09876547" /> Then the lines follow <B2 <C1 The...
  2. C

    Search a string to find "whole word" from list

    Column A contains strings Column D Contains a list of words to search for Column B returns true if whole word found Only return true if whole word is found eg Dog not DogD If not in list return a null cell ---- If possible I would a more detailed result Column A contains strings Column D...
  3. C

    Searching for information and then returning that info.

    Each day I get in a bank statement, and on there I need to search within the reference column for specific text in the form of invoice numbers. but to get around the fact the invoice numbers and letters are different, I want to make a table with these values in, but have wildcards in between...
  4. M

    If X is greater than Y in a cell

    Hi I've got three formulae that work in isolation, but not together. If the text "4 for 10" is in cell A1, I'd like one formula that returns the text "Multi deal where X<Y" if 4 is greater than 10, which it is. But returns "Multi deal where X>Y"if the text in cell A2 was 10 for 4. The...
  5. M

    searching cells for specific conditions

    Hi I have data where the word "for" will appear in cells and if two numbers in the cell are the same, then I'd want to return the word "volume" and if the first number is bigger than the second, then I'd want to return the word "value" To give a simple example, let's assume that 3 for 3...
  6. B

    QUESTION: Finding cell text in other cell text, returning value from third cell

    I need to determine if the individual cells in column A (A1:A17933) contain text from any of the cells in column C (C1:C1957), and if so, return the column C cell's corresponding value in column D (D1:D1957) to the column B cell next to the column A cell containing the column C cell text. For...
  7. M

    Help with changing an existing VBA program

    I have been using the VBA program on Excel 2010, Windows 7 below but I would like to change it from searching one number to one set of numbers (see my notes below) entered in cell C17. Can this program be used for that purpose? Wondering if someone could look at it and provide any feedback...
  8. H

    search loop

    Hi, I need some help with creating a loop macro, hope someone would be so kind and help me i need to search all cells in a range (b2:y200) if a value (value would be a name - so text) is found, i would like to go to sheet ("data") find the value in range (B2:B100) and copy the cell to the...
  9. W

    Categorize text with keywords

    Hello, I am attempting to use a formula that will search for key words in text fields of cells and return the appropriate category> <colgroup><col><col></colgroup><tbody> =INDEX(CATEGORIES,MATCH(TRUE,ISNUMBER(SEARCH(KEYWORDS,A2)),1)) I am using this formula. But keep getting an #NA...
  10. S

    Can someone tell me why this formula always returns no unless I put the WHOLE search string?

    This is the formula I'm attempting to use (which, I have used in the past and no issues): =IF(ISNUMBER(SEARCH("Sport Slotted - GM - 126.62092SL","Slotted")), "Yes", "No") This Always returns NO unless I put the whole search string as "Sport Slotted - GM - 126.62092SL", which defeats the whole...

This Week's Hot Topics

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
Top