1. 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...
  2. 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...
  3. M


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

    COUNTIF INDEX type issue. Producing a summary table..

    Hi folks, After success on this board earlier this week, I’ve decided to put together a management information type system for my department at school. I currently teach at different sites and I’m trying to ensure an even split of equipment between sites. I’ve put a simple site, course and...
  5. 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...
  6. 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...
  7. F

    What does the combination of Index and Match do?

    Hi all could someone explain what is this line of formula doing in Excel ? INDEX($C$26:$W$39,A27,MATCH(Fmax,Cf,1))
  8. L

    Index match, xlookup or both?

    Hi, I'm trying to find a way to return a value based on an index match formula, if the returned value is 0 then move up until there is a number. Column look up: A Row look up: 4 A B C D E F 1 0.34 0.36 0.24 0.75 0.37 0.12 2 0.15 0.74 0.35 0.01...
  9. A

    Pulling List of Rows from other sheet dependent on matching Cell Value? HELP See Pictures!

    Hello, I have a workbook with Sheets 1 and 2 with data on them. This template is on Sheet 3. The template uses the cell D5 to pull data from these different sheets to populate. You type a project number (Proj#) in D5 and the rest should populate. On "Sheet 1", I have a listing of all the...
  10. E

    Index & Match functions in VBA

    Hello guys, I'm trying to create a small VBA script but i m stuck with the index / match functions. I have this error: "Compile error: Object required" for the Match I'm pasting my code below: ' Define params for index and Match functions Set ws.Release =...
  11. G

    formula to match next value if value is in row above.

    I have this formula, I am running into an issue when I want the nth value, but it matches the nth value for another column, then does a match to get what value in this column. Visual is below. Column B matches the index of Column C to return a value based on the value. I want it to show what the...
  12. B

    Match then highlight and return value.

    Hi There, How can I have the return value highlight in another workbook before being matched and copy into first workbook. =INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type)) Thanks in advance
  13. L

    How to return the starting balance of a bank account in a master list of bank accounts

    Hi everyone, I've built a workbook that evaluates a client's banking information and processes multiple bank accounts at a given time. I'd like to find a formula that will return the starting balance of each unique bank account from my dataset to reduce human error with data input. The...
  14. A

    Formula to check range cell if match then check the cell value and return true or false

    Hi there as per title I would like to run through below under a single cell. However I couldn't figure out which direction should I go to get the exact outcome. Here is the logic checklist I wanted to do and return the outcome: Staff A have 5 columns and each have 7 working days ranging C6:P6...
  15. H

    Multiple Matches

    Hi, After previously having a huge amount of help via this forum previously I’m hoping one of you excel gods wouldn’t mind looking at another thing that’s got me stumped. So I’m trying to identify where a telephone call has been made by an agent during a time period they weren’t supposed to be...
  16. S

    Finding values in multiple rows or columns, then returning the first value in the row or column

    I spent a day reading Excel Help articles and trying many different approaches to solving this, but have not been successful. If anyone can help me with the proper formula to make this happen, I would be most grateful. The goal is to identify which physical host (Hostname) a vm computer...
  17. S

    Sum only up to a certain point, then reset

    I have a list of staff with the hours they have worked on a weekly basis. I want to be able to put in a week's column when a payment has been made (this can be done sporadically and so isn't every week). When I put this in a column I then need a row below to reset for the following week to only...
  18. I

    VBA - INdex Match Multiple results

    0 I have two sheets (As Diplayed Below). Sheet 1 or INformation is where i have all of my information Stored. And Sheet 2 is where i want it displayed based on the Urgency (Tab Selection). Please can someone help me with a VBA code which can load this data on each of the Sections on Sheet 2...
  19. V

    Index Match entire row descending order

    I have rows of data I am trying to Index Match variable amounts of dates from. I saw a blog mentioned descending order can extract the highest, then lowest matches. Table example: Bob None 1/1/2020 None None None 1/3/2020 None None None Stanley 1/10/2020 None None None None None None...
  20. W

    Return MULTIPLE corresponding values for TWO Lookup Value, Horizontally, in one Row

    Similar to this link(reference the bottom)- I am trying to return multiple corresponding values with two look up conditions, horizontally, in one row. Then I can apply it down other rows. Not sure how to go about this- I have been stuck for days. I provided a sample below: ID Name Qty A...

Some videos you may like

This Week's Hot Topics