partial match

  1. P

    VBA loop with wildcard in Sheet name

    Hi All, I'm pretty new to VBA, this is my also my first time posting on here. Hoping somebody can help me tweak my code; The code loops through all the files in a folder to copy data from a sheet called ("P&L 2019 - UK GAAP") into one workbook. The issue that I'm having is that, a couple of...
  2. D

    Partial matching to multiple cells

    Hello all, Please see the attached image below. I am having trouble with partial matching & joining together results. As you can see, I have recipes 1-5 in column B, with corresponding days of the week in column A beside them. The letters in column A correspond to days of the week. For...
  3. S

    Find best partial match(es) for substring(s)

    This might be an impossible task, but I'm in a de-duping project and was hoping to write a formula that could plug in a string from before the @ in an email address, say "harrystruman" and then compare that to a range of values in a column or columns, and find the best match or partial match (or...
  4. D

    match text combinations across multiple columns

    Hello! I am trying to find matches between multiple columns of text and having a terrible time getting the formula correct. I had 2 individuals rate items using 2 letter codes. They could give each item between 1 and 4 different two-letter codes (with 9 unique two-letter code options...
  5. T

    From Drop Down lookup partial values

    I have a Drop Down. Assume I select "Varia Single 25/2,3 90" Now I want to return other values where either 25/2,3 or 90 are included. I want the whole value to be returned. List <colgroup><col></colgroup><tbody> Pexflextra 25/2,3 90 <tbody> Uno 25/2,3 76 <tbody> MX-Radiflex 40/3,7...
  6. C

    Index match first value that contains "@"

    Hey, First time posting. I have a data set with duplicate account keys and values in the form of email addresses. I need to create a consolidated data set that has only one account key and a corresponding email value. My issue is this -- some of the duplicate account keys have blanks or "old...
  7. L

    Partial Match Index Left Mid 2 sheets

    I am working with 2 Sheets in a workbook. I am attempting to run a PARTIAL MATCH from SHEET1, COLUMN C to SHEET2, COLUMN A. When there is a match of 5 digits, I want the value in SHEET2, Column B in the same row as the match, to be placed in COLUMN G of the row matching SHEET1, Column C. I...
  8. S

    Multiple Criteria IndexMatch/ VLOOKUP with partial match

    I have a file with all the state and cities that I need. I want to match the population of the US census dataset to the cities in my list but the cities are not in the same format. This task would be easy if there weren't multiple cities that show up in different state. What I want the formula...
  9. A

    Finding Partial String while using List as a Reference

    Hello Wizards of Excel, I'm in a bit of a bind I'm trying to find a partial match within a list of keywords. I'm looking for the return result to be the word found in the list. I tried vloookup and index match, but the problem is that it only finds the exact match of the word and doesn't take...
  10. S

    IF AND Statement partially matching criteria

    Hi, I currently have the formula below looking a set of data comprised of people and percentages. The formula currently looks at if a person is in the bottom 20% and are below the target (0.815). From this it produces either a 3 if they are both below target and in the bottom 20% or a 0 if...
  11. S

    Move entire rows based on partial match from ColumnB to another sheet

    Hi Friends, Did search on this forum for my solution. But did not find a suitable one. Here is what I would like to get it from list of sentences. Here we have to take a look at row 5 contains "entire row" text and row 6, 7 contains "entire rows" and also contains work "quickly". (In attached...
  12. 9

    If cell contains partial text return value from other cell

    Hey! I have 3 cells, 2 are with names, they are not sorted, as they are extracted from two different webpages. Basically eg. Cell 1 (full namem, random order): Masahiko Inoha Cell 2 (partial name, usually the following): M. Inoha (in some cases however full names) Cell 3 (extracted web code...
  13. S

    Formula to match partial text string

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

    Partial Match Columns Data within two sheets

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

    ANY text contained in cell C2 is ALSO contained in cell B2 (Fuzzy Match)

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

    Compare part of cell contents with another column

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

    Index Match with partial match

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

    Partial match in two columns and delete duplicate portion

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

    partial match vlookup with string

    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 =...
  20. S

    Delete row using array, don't delete on partial match

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

Some videos you may like

This Week's Hot Topics

Top