substring match

  1. Michelleaneous

    Return a value based on a substring from a cell in Google Sheets

    How to return the "Ship From" in Cell B2 based from the data in another tab with a substring criteria in Col A (currently listed in Col E/F)
  2. D

    If Substring from a List contains Subtring, return that item from the list

    I have a column containing broken/good domains I want to compare it to a list containing all the correct domains, and return those from this list that partial matches with [Email Domain]
  3. C

    Find first matching substring in a list and return adjacent value from another list

    Hi there, I am trying to find a way to harmonise the way a product is coded from various ways people may have entered it (i.e., the cut of fish - in parentheses here but note that this is not always the case). For example, in the sample data below, "Gutted" and "whole gutted" mean the same...
  4. S

    Find best partial match(es) for substring(s)

    This might be an impossible task, but I'm in a de-duping project and was hoping to write a formula that could plug in a string from before the @ in an email address, say "harrystruman" and then compare that to a range of values in a column or columns, and find the best match or partial match (or...
  5. S

    Comparing unique strings in two columns and updating third column

    Hello I am trying to find a string in Column D and Column H and if they match certain criteria, insert the string "Match" in Column W. For example, if the string "Auditorium" occurs in Column D and the string "INTERNAL" occurs in Column H on the same row, insert the string "Match" in Column...
  6. R

    SEARCH function only finds full string, but not substring

    Hi all, Background: I was searching for a formula (for conditional formatting) that checks if a specific cell (text format) contains a specific text of an adjunctive cell as a substring. If there is no match, the cells should be highlighted red. As an example: <tbody> 01 ABC_01_XXX 22...
  7. M

    VLookUP type but reverse substring Matching

    I have data in 2 Columns. A: Addresses B: List Of Different Areas Column A will be much much longer (more cells/rows) than column B. Like this: <tbody> A B opp-don bosco school,jivraj park Shyamal pearl apartments, opp. shakti school, near shyamal cross roads, satellite Ramdevnagar...

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