match text

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

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

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

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

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

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

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