partial matches

  1. T

    VBA - Compare 2 columns for partial matches, and return only last 3 characters of matches

    Hi all, I’m trying to – Compare Column G from Workbook 1, starting from row 2, to only the first 10 characters in Column A, starting from row 9, from Workbook 2 for matching values If there are matching values, copy only the last 3 characters in Column A from Workbook 2 to Column F from...
  2. T

    Lookup from multiple criteria, including potential partial matches

    Hi Everybody, Hoping somebody is able to help me with this formula. We have multiple departments and project codes so the actual file is much more comprehensive. I've scaled back for the sake of this example. Currently the formula below looks up the project code and the date and compares...
  3. 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...
  4. S

    Matching ab cd columns and get e column data

    Hi Friends, I been trying to match 4 columns like AB with CD to get E Column data into F column but could not able to get there. Here is sample sheet which I am trying to match. Hope you understand what I am looking for. Thanks Kumar
  5. M

    VLOOKUP using text

    Hey Everyone, I'm sure what I'm thinking of is possible, but I am struggling with using VLOOKUP within a text string. Below in my example I need to compare the test name in column C to the test name in Column A. When a match is found I need it to fill in the corresponding numeric test code...
  6. M

    Fuzzy Logic? Partial match to retrieve values from separate table

    I have two sheets in Excel 2013: One contains more than 200 Brandnames, plus their importance on an increasing scale starting at 1, plus a category. The second sheetcontains more than 13,000 keyword phrases, which may – or may not – contain the Brandnames in the first table. What I want to do...
  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. S

    Partial String lookups - PLEASE ADVISE

    Dear Fellow Excel Geeks: The totality of the problem is: We have our own in-house database of customers (about 20,000). These customers are assigned to specific Sales people. We also buy in new databases and allocate these leads to Sales people. Before we can allocate them, we need to...
  9. W

    search macro retrieving all occurances as well as partial matches

    Hi there<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm working on a database for a Dutch nursing home, which - if I ever get it to work properly - will eventually contain data on several hundred people. To help users navigate through the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top