match text

  1. D

    compare words in text with a list of comma separated terms

    Hi I'm looking for a vba solution for the following: Sheet1 Col A: Group Name Col B: list of comma separated terms (for this Group) Sheet2 Col A: text string Col B: Group Name I need to loop thru all the Groups in Sheet 1 and check if any of the terms in Sheet1 ColB...
  2. J

    VBA Match Text With Different layout

    Hello I have two worksheets with data that I need to compare. In sheet1 the data looks like this (screenshot below). Notice that the order of the values in column AG can change. -- removed inline image --- In sheet 1, I need to compare the names and their respective values with the names...
  3. L

    Confirm matching text in cell and then return a numerical value from a table

    Hello all and thank you for your help. I've run into an issue in Excel, and I cannot seem to get any formulas to work. This may be beyond the capabilities of Excel, but here goes. I need to perform the following functions and return a single value: 1) Search a text string in a single cell to...
  4. J

    Advanced Conditional Formatting: If Any Word GREATER than 1 Character in a cell, can be found within another cell.

    I can't wrap my brain around this scenario to come up with something. Spelled out this is what I would like conditional formatting to do: Highlight a row if ANY word in A2 greater than 1 character, can be found within cell B2. Why we need it: We're trying to quickly identify which names in...
  5. P

    vba code to search through list

    Hi, I need to search through a list of part number matching a value. At the moment the code I have is not really efficient as it goes through the entire list of part numbers using a for loop. This takes a long time. Is there a equivalent vba code to 'find' option, if so can I have some help...
  6. D

    Grab Corresponding Column based on Drop Down Header

    Looking to modify existing formula that works to allow for use of a drop down header and then lookup the corresponding column based on the year portion of the drop down. So in Column Q starting at row 2, I have the following...
  7. J

    search certain part of cell

    http://lh3.ggpht.com/_caK9XMuXnSw/S2m3s9teApI/AAAAAAAACtI/XIU7LTqAzdg/s800/SCREENSHOT.JPG <a href="http://picasaweb.google.com/lh/photo/A8A7SWGnHkpqFZaUnjxIXw?authkey=Gv1sRgCJbSs4a3h7PnRw&feat=embedwebsite"><img...

Watch MrExcel Video

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