partial matching

Dear friends, I need to use formula =SUMIFS() and sum the results from two columns from one table matching with other two columns in another table. =SUMIFS('Active link'!$G:$G;'Active link'!$A:$A;$A4;'Active link'!$D:$D;"*crushed stone*") But if for the first column it should match the whole...

Hi Friends, I spent few hours to findout a solution for my task. Trying to partial match first 2 or 3 words from ColumnB(B1) data with First 2 or 3 words from ColumnG(G1) If found the partial match then mark as "Yes", If not, "No". I do not need to input range like G1:G10 because the correct...

Hi Friends, I am trying to do partial match but its not pulling correct abbreviations. Attached sample file. Used this formula but did not pull right one. <colgroup><col width="64"></colgroup><tbody> #=VLOOKUP(F1&"*",Sheet2!A:B,2) </tbody> https://spaces.hightail.com/space/M8AAa4mCKO

Hi friends, Trying to do partial data match of ColumnA and ColumnB in ColumnC for example Here is the sample file with result and highlighted what text have to be partial match. I am not good in VBA macros. Tought that it is only possible VBA macro. https://spaces.hightail.com/space/Gf86h0pqLW

Hello. I have two columns I and J that have some model numbers in them. Model J has model numbers that are longer than those in column I. I want to have another column F that looks at I2 and searches column J for a partial match (7 characters) and once it finds one, it copies the date from...

I'm working on a project which provides two excel files. The first file, File1, contains a list of SKU descriptions under the header "SKU". They are somewhat long, and contain superfluous information. <tbody> SKU(A1) <tbody> M GEL-CUMULUS 14 M GEL-CUMULUS 15 M GEL-CUMULUS 16 BR W...

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

I've recently taken up a project for my internship that I thought would be fairly simple. Basically I have a list of companies with email addresses and another list without. I want to match the companies with email addresses with the companies without based on their name, then combine the data...