partial matching

  1. P

    Insert *data* from a cell in SUMIFS formula

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

    Compare part of text columnB with columnG

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

    Partial match sheet1 in sheet2 get columnB

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

    Partial data match from ColumnA and ColumnB in columnC

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

    Partial Matching and copying over a separate column when a match is found

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

    Index Match with wild card help

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

    Match text and numbers from two spreadsheets based on common value

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

    Partial Matching In Excel?

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

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...