1. F

    How to make vlookup partial match digits from left to right?

    Hi all, I'm trying to get a formula to do exact and partial matches. I use INDEX(...MATCH(...)) to look for exact matches and if fails, then I try to do partial matches using VLOOKUP() but is not showing expected output. The partial match should show the "best match", this is select the...
  2. D

    Find Partial Text and Return First Part of the Word

    Hi, I'm looking for a formula that allows me to search for a specific partial text that is part of a word, and then return the characters that start off the word. So for example, I have a cell with information like "English, Maths, Science, Community Skills, 45C/English, 3A/Maths, 5B/Science"...
  3. P

    Macro runs fully in debug mode, but partially only when played

    Hi, I have a simple macro to copy-paste formula over a range of active rows. I've used Dim statement to identify the last active row using worksheet countA function. And then written statements to copy formula from a specific location and paste in a specific cell for the active number of rows...
  4. D

    Search Range For Text That Matches Part of String After Last Comma

    I am trying to match partial text in a string with text from a range on another sheet. The text fragment in the string is usually found after the last comma. For example: P38 Some Noise Text > Other Noise Text > 12-3456, 7890 Text I Want The range on the other sheet (Sheet2!$B$2:$B$505) will...
  5. S

    Conditional Formatting of Partial Data

    I’m looking for help on how to conditionally format several worksheets in a workbook. Each worksheet already has a different type of conditional formatting in areas that I would not want affected by the new conditional formatting. I have two columns (A and B) with approximately 50,000 cells...
  6. I

    Partial match index match with array values shorter than match value

    Problem: Trying to run an index match_partial match on a long column of values to return the desired result but have been getting an #NA. Current formula without changes: =INDEX(level,MATCH("*"&J3,title,0)) So I'm trying to match these values to return "Middle Management" for values that...
  7. S

    sumproduct - multiple criteria that includes partial text

    Hi I have a table of data with many rows an columns and I'm trying to count the number of records that meet numerous criteria. I've managed to get a lot of it to work but am stuck when it comes to one field that contains one or more partial string elements. My current formula is: -...
  8. M

    Excel Sumproduct formula with Wild Card

    Hi Team, Need your help , in sumproduct formula, I want Count of Partial Match. and also how to use not Equal in Partial Match using wild Card. Below excel formula gives correct result. for Exact Match. Need some change in Third Criteria. highlighted in bold...
  9. D

    Returning Partial Data using Vlookup

    Hello Everyone, I was wondering if anyone might know how to return only partial data using Vlookup. I would like to only bring back the first name instead of the full name when doing my vlookup. Thank you for any help anyone can give me. Thank you. D.
  10. M

    Items picked per partial hrs not full hrs ( items / time)

    Hi I'm using excel 2016, with data running down the columns Q,S,T it calculates items divided by hrs, but I'm stuck as i have partial hrs and this over inflates the value in T1, is there anyway i can make it more accurate say to the nearest 15 minutes also how do i remove #DIV/O! as my...
  11. S

    use reference cell to return dropdown list of partial matches

    Hello, I am trying to pullup a customer# based on their name in cell D1. There can be many customers with similar names. I am looking for help to populate a drop down list which the user can select to get the exact match. The cell D1 is populated by a designer, who may use apostrophes...
  12. S

    Find and Highlight Partial Matches in ONE COLUMN

    Hi, I have a list of people in Column (A) followed by their home addresses in column (B). I would like to find a formula that will look at ONLY column B and highlight any cells that contain partial matches of home addresses to another cell in the same column B. I only find formulas that work if...
  13. R

    SUM with partial cell content in a range

    I need to SUM a range where some of the cells contain partial text as below: 5 6 2 L5 4 SUM should be 22 taking the digit from second last cell also.
  14. X

    Excel partial match from unequal columns and assign value to new column.

    I want to assign a category to a table so that I can eventually create a pivot table. I need to do a partial match to get my category values. "num" i want to match to "number 111" and "numeric 321" and then assign both of those as category1. "form" i want to match to "Form 1" and "formula" as...
  15. S

    Protecting Partial Rows and Columns

    Hello, I would like to know if there is a way to protect partial rows and columns. As an example, I have a spreadsheet that has data in Columns A - F and through Row 3. I don't want that data to be editable except via a password. However, I would like a user to be able to add more columns after...
  16. E

    Subject: reverse partial lookup.

    Hi, we need to do a “reverse partial lookup”. i.e. we have a list of old_product_codes (Col A) and new_product_codes (col B). And we need to know if any of the new_product_codes contain (or equal) any of the old_product_codes We have found ways of making this work on smaller lists, but we...
  17. S

    VBA Macro to open Find box and search multiple worksheets

    Hi all, great to be here in the community ad thanks for having me. I am basically wanting some VBA code that can be used as a macro to open a find box, then input either a partial text or partial number. This in turn then searches specific worksheets (example worksheets: MON01, MON02) of which I...
  18. M

    PO wise supply issue

    Hi all, I have a problem in issue the products on the basis of PO wise ( PO means purchased order issue by Hospital with all term and condition QTY, PRICE ,Supply, etc. ). We can’t serve complete PO qty on a one day with different reason but issue to hospital on demand basis. There is a problem...
  19. P

    Lookup and partial match to Filtered visible cells

    Hello. Please refer the attachment. The Data List is in column A with multiple words in a single string in each cell A14:A17 Column A (starting at A13) <tbody> Data List JohnMarySue SueJoeNathan KellyBobThomas ShaunSisterMale </tbody> The Filter list of unique words are in F1:F10...
  20. K

    Help with Date formula

    I posted here and got some help, but not exactly what I need: I will do my best to explain what I need My company went to a monthly calendar reporting period with 12 reporting periods...

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