partial match

Hi, I have looked at various threads on this forum and nothing appears to get the solution requried. I have the following formula but I want to adapt it so that I can return row numbers where there is just a partial match of cell M4. At present it matches everthing exactly as it is in cell M4...

Hi Friends, I did research related to my task but did not find exactly what I am looking Trying to partial match Sheet1 columnA with Sheet2 ColumnA and sheet1 ColumnB with sheet2 ColumnB and get corresponding sheet2 columnC data to sheet1 columnC. If possible, also Reverse lookup and partial...

I've been searching for a formula on the forum for some time now and have not found this exact scenario. I'm looking to have a formula that indicates if there is any text in cell C2 that matches any text in cell B2. Yes B2 C2 Acme Mfg. ACME MFG CO No B2 C2...

Hi, I have spent a few hours trying to find a solution for this but feel the time is now right to ask for help! I have a spreadsheet with address details in column A for around 100 of our company sites. In column B I have address details of all the properties our company visits, which includes...

I Have an extensive spreadsheet, with very long text cells: Content Spreadsheet with cells like: (about 20.000 lines) 1. Complete/Long Manufacturer Name 2. Complete/Long Product Full Description 3. Lookup columns to be added: [*=2]Part Number [*=2]Type of Product [*=2]Classification...

I'm trying to add a snippet of code to a macro. I can find several vlookup functions, but nothing in a macro. Here's a simple example. Column A contains First name and column B contains last name, normally. Sometime Column A contains First name AND Last name, while column B still contains...

I'm trying to do a vlookup with a partial match. I have a set of Item IDs and I'm trying to identify their item categories. Each item of the same category has the same abbreviation as part of their ID. IDs ABC12342 xyz DEF73829 yzx GHI93592 zyx Key ABC = Category 1 DEF = Category 2 GHI =...

I have a text file with thousands of lines, one word per line. I'm trying to delete/remove lines that do not include one of multiple values, but not delete if there is a partial match of one of the values. This almost exactly what I'm after: <code style="margin: 0px; padding: 0px; border: 0px...

Hello. I am attempting to count the number of instances of partial text matches for records that correspond with a specific month. For example, in the month of July 2015, I had eight accounts place 39 orders. I need a formula that will count the number of accounts active that month. I'm familiar...

Hi, I've tried searching this forum and Googling for help on this, to no avail. Was hoping someone here might be able to help me out. I have two tables, Table 1 and Table 3. Table 1 has Page Urls in Column A and the Column B has the Page Type, which is where I'm putting the formula. Table 3...

Hello Dear Friends, I think most of the people faced with fuzzy match (partial match) problem found the following tutorial posted by Mike Girvin ExcelIsFun) and discovered a surprisingly interesting solution that starts with = LOOKUP(2^15(SEARCH(....... Here is the url to the video...

Hi guys, I am doing retrospective research in liver enzyme's elevated patients . I am have two columns of ID's ( around 30,000-50,000) which i want to compare and see if there is a match. I do want a partial match between the numbers in each column of 5 digits . A is the premanent group. C...

Hi everyone, I am working on a file that requires constant use of underscores. I would like to hide these underscores. I having been trying to find a way to select all instances of underscores (in unhidden and hidden sheets) and change the font to transparent. The closest I got is the...

I have two columns of data: Column A = Account Numbers, Column B= Transaction Description with Account Number They cannot be sorted to match and they are not in any particular order. I need to match column A to the correct description in column B, and preferably have the matching account...

I'm a teacher and I have a vocabulary database of common English words--and the many derivatives of those words--that I want to teach my ESL students. I've manipulated the database to the point that it looks like this: <tbody> Singular Noun Plural Noun Base Verb Form First Person...

Hello, I am trying to use vlookup to pull data from one sheet into another. Presently I have had to have the formula ignore part numbers longer than 11 characters and drop the 12 character in order to get it to work. =IF(OR((VLOOKUP(LEFT(C13,11) &...

Hi, I have one spreadsheet with two columns, with the headers: ID number and Chemical name. I have another spreadsheet with six columns: ID number, Chemical name, TEP 1, TEP 2, TEP 3 and TEP 4 (TEPs are numeric risk scores). I need to know what the TEP values are for the chemicals in the first...

Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a question regarding looking up value (one word) from a range of cells. Here’s the scenario-<o:p></o:p> <o:p> </o:p> I have a existing list of companies with their corresponding...

I am trying to apply the index & match formula to find a category based on a lookup table. This needs to work when the list of names in the lookup table matches any part of the searched string. Here is an example: <TABLE style="WIDTH: 267pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0...

Hello, Would really appreciate your kind help here...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have 2 lists of customer names (from 2 different systems) as a result I have multiple names for the same customer. (even in the same list)<o:p></o:p> So...