match

  1. P

    Formula to determine if a date and time are within a range.

    Hello, Completely stumped here. Thought I would take a change and add some experts. I need to be able to reference a table that is attached as an image. I need a formula that can read a cell that says "44027 11:00" find where it is on the reference table and return the code associated with...
  2. 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...
  3. A

    VBA - Max Values and Match

    Hi all, I am stuck on a problem. I have need to insert a vba macro into a sheet for my admin team. I want to find the highest value from a range in one sheet and return the value to another sheet if the adjacent column matches. I also want it to return it to the next blank cell in that row...
  4. H

    Multiple match criteria in different columns to return the unique value

    Hi, Can somebody help me with this problem? Thanks, Bobby
  5. I

    Formula for identify related cells based on a common criteria

    Hello everyone I am looking to identify family members who are eligible for a benefit. Let's say govt. has identified a set of eligible fruits that qualify under benefits. If any family member sells one of those fruits, all family members become eligible for benefits. All family members are...
  6. D

    LOOKUP formula problem

    Sorry for the vague title. Trying to get this done in a nice way, but feels more difficult than it looks. I have two tables - Strings and Data. Starting off with data in grey columns and I need to extract verified data to green (already filled as a manual "to-be" example). Values in table Data...
  7. X

    INDEX/MATCH within an Array

    Hi I have a large report that I am pulling into a multi-dimensional array. I'm then using a function to remove dupes and then running various loops summarizing the data from the main array, but I am stuck on one point. I can't find a way to use INDEX/MATCH functions within arrays. ie if I was...
  8. F

    Using Match to return the highest value for a coincidence

    Hi, this is my first post here! The reason i suscribed here is because I was looking forward to improve a formula to match my needs. Let me tell you about it a little: I have this data set: When you put an X on column E it sums always the value that is displayed on there, no matter what...
  9. HawaiianShirts

    Index Match with Constant Row and Variable Columns

    I'm creating a worksheet (Data) that will reference another (Sheet1). In Sheet1, the data will change periodically by being pasted in from a form filled out by someone else. The trouble is that the form has three versions, and each version has a slightly different number of columns. I need to...
  10. D

    How to use VBA to color cell interiors yellow if cell.value in Address table matches cell.value in Postal Town table?

    Hi Folks, I'm looking at a variety of ways (using VBA) to colour cells in an address table whose values match values postal towns in another table. There are two tables: AddrTable (contains 10 columns) PostalTownTable (one column) As the address data in AddrTable can run into many thousand...
  11. T

    Improve formula for dynamics list unique values based on two criteria

    I want to improve the formula for extracting unique zip code for 2019. I am currently using this formula but its very slowly: =IFERROR(INDEX('Project Data'!E:E;MATCH(0;COUNTIF('Dashboard Sales'!G114:$G$114;'Project Data'!E:E)+IF('Project Data'!L:L>=$E$113;1;0)+IF('Project...
  12. B

    Partial match when look up value is lengthier than corresponding value in a table or a range

    I have table as below. In first column name of the company and in next column corresponding manager Name. Company Name Manager Name Amcor Amol Thermax Sagar The look up value of company name is not exact match in this case. e.g. It is "Thermax Ltd" The company name from table is a...
  13. M

    INDEX, MATCH type COUNTIF/SUMIF issue.

    Hi everyone, Last time I reached out to you, I felt the love with so many responses so quickly. I am a teacher and I’m trying to look for ways to streamline my duties. I'm currently reviewing the courses I teach - focussing on equipment used, and duration for each module. I have been asked...
  14. R

    Vlookup and Match-Need VBA solution

    I am facing a problem with vlookup and i think could not solve using the Excel formula The column H values to be checked in Column A and if the words in a cell match, then it should collect the adjacent values and display in Column C and D with comma seperated. The column H values to be...
  15. M

    Help with index match sumif and more.

    Hi there, I’m a teacher who is looking to prepare better for the academic year. I teach a range of courses which require different amounts of time to setup and I’m keen to get a better understanding of the set up times for each course I teach. I have attempted todo this is a matrix format, but...
  16. E

    Match & offset or index/match?

    Hi, Trying to match a value and return the a value offset to the left. The values to search in are in the columns B to E (as per the table) I want to return the Level in column C I know two values (these come from another tab) 1. The row heading (Red names) 'Risk template'!F5 2. What I'm...
  17. M

    Match formula to exclude criteria

    Hello! Wondering if could have feedback on writing a formula that excludes specific criteria from a list. I started a formula that saysIF(ISERROR(MATCH(cellA1,lookupcolumn,0))=FALSE. I’m confused by ISERROR. That essentially returns true if there is an error or false? I want to write a formula...
  18. P

    Match and Merge data having same pattern with a delimiter

    Dear Helpers, I am looking for VBA Solution which is very peculiar situation and crack my head to do it as Simple but could not do that. I request this could be done by a Macro and seeking your kind Help. - Overview Sheet 1 contains Column A and Column B - Column A has unique values to be...
  19. M

    Count Zero's Across Rows if column A Matches

    I could really use some assistance in trying to figure out how to count the number of times the value 0 shows across many, many columns, if the value in column A matches between the two sheets. Once I solve this, I hope to reuse the formula further and query how many times it is greater than...
  20. X

    INDEX and MATCH through 2 Sheets.

    I am having a complete mental shutdown right now. Basically I'm trying to get match&index to look at sheet 1's SKU and match with Sheet 2's SKU to display the QTY from sheet 2, int Sheet 1's (DISPLAY Column) I got it to work using only 1 sheet with the formula =INDEX('magento...

Some videos you may like

This Week's Hot Topics

Top