index match

  1. A

    How to Combine Sumproduct with Index Match

    Hi I have following Table: A B C D E F Yr21 Yr22 Yr23 Yr24 yr21 £10,000 yr22 £8,000 yr23 £12,000 I am looking for following: A B C...
  2. C

    INDEX Match to show a tie

    Hi, I am seeking help in a formula to show the results from evaluation that either shows if the consensus is either Exceptional, Satisfactory, Unsatisfactory or if it the outcome is a tied result based on the evaluation selection from other cells. Column "O" should show the consensus of "K-N"...
  3. C

    Convert Index Match to User Defined Function

    Hello, I'm new VBA and have been trying to covert a standard Index Match function to a User Defined Function in VBA to simplify the formula for users. (As I understand it, since the cell the function is in will change a UDF is required.) I have three functions I'm trying to figure out. I'm...
  4. P


    I have been racking my brain on this one and can't find what I'm looking for to line up names and positions from one sheet to another and to add to the difficulty if there were duplicates with the same time and position that the 2nd entry for that time and position would go onto the TRN line of...
  5. P

    Index Match?

    First off thank you for the help! I have a daily schedule on Sheet1 and have the Employees entire year schedule on Sheet2. So what I have been trying to do is get the names from sheet2 on to Sheet1 by date and position. I have tried INDEX MATCH looking for the date then the positions to no...
  6. T

    VBA for index match and vlookup function

    I have a code that run the index match and vlookup function, but the problem is that the data I receive is not always the same (sometimes only 3 or 5). When I run the code, the code always ask me to update the value of the unavailable sheets. here's my code Sub Function() Dim ws As Worksheet...
  7. A

    Index Match Array formula partially working Google sheets

    Hello! I've got a question about an array index match formula that's partially working. So the set up of the data is on sheet2 I have the raw data being downloaded. On sheet1 I have a table with the formulas pulling back only the relevant information from the data dump. The table set up is...
  8. T

    Using Dynamic Named Ranges in a Formula With INDEX, MATCH and MAX via a Dropdown Cell Containing the Range Name

    Hi all! I have tried to find a solution to this problem, but so far nothing I've found has either worked or explained why it can't - so I'm turning to you guys! I have a standard data table from which I wish to display the maximum and minimum value of a given criteria using in-cell dropdowns...
  9. P

    counting particular hierarchical column with condition

    I would like to count the number of 1s (on the left) and organize as shown on the right. notice rows 1 and 2 are hierarchical. in other words, something along the lines of "count soccer players in 2020 in Europe" My attempt was to first match headers then count the column returned by INDEX, but...
  10. M

    Index Match / lookup using column names and

    Is there a non-array Index Match formula that references field names instead of specific columns and allows for multiple search criteria? Here is my original post that solves the "reference field names" function: Index Match / lookup formula using column names Can I expand on this approach to...
  11. T

    Excel VBA - Arrays instead of Index Match formula

    Hi all, I have 2 workbooks and would like to lookup row values using the common columns of Workbook 1's Column B and Workbook 2's Column F, match corresponding row values in Workbook 2's Column I, which is empty, to Workbook 1's Column Q. The Index Match formula in...
  12. T

    Exact Index Match Returns a Value when it Should Not

    Hi all, I am working with healthcare data in two different worksheets. In my first worksheet, I have a patient unique ID (which is simply a concatenation of their full name, sex, and date of birth) as well as their medical spend. Due to privacy reasons some patient full names are masked with...
  13. Sumeluar

    Index match to specific month

    Folks, what am I doing wrong? I have a table which contains two columns "Date" (Column EJ) & "Description" (Collumn EK), I want to use Index to pick all the events form April but I cannot get the formula to work. Here's what I have: =INDEX('Perpetual...
  14. B

    Index & Match in VBA

    How do I convert the following formula to index match in VBA? I cannot wrap my head around this...I am trying to learn but im struggling. =INDEX(rngLabourRates,MATCH(D13,rngLabour),0) I have made the following vlookup code work to accomplish what i want but it returns an error when there is a...
  15. dss28

    VBA code for Index Match function

    I am using Index match function in excel to retrieve values from a sheet ("MasterData") to another sheet ("Report") using a specific unique number which the user enters in a cell in sheet "Report" . This populates a table with about 6 columns and 15 rows as per the data available in...
  16. G


    Hello, I am doing a vlookup on one column's values which includes multiple data types (dates, number, or #N/A for not available. The one column's results will either be: 1) a date (formatted MM/DD/YYYY) 2) or it will be a number, positive or negative 3) or it will be not available (#N/A)...
  17. U

    VBA FormulaArray Syntax/AutoFill/Set Ranges

    Hi all I am trying to do a few things here with VBA: Here's the source Worksheet named MoCMatrix ABCDEFGHIJKLMNOPQRSTUVW1HELPER ROW > Structural Integrity-MoCStructural Integrity-Substantiation DocumentStructural Integrity-StatementFlammability & Smoke-MoCFlammability & Smoke-Substantiation...
  18. E

    Dynamic Dropdown List Error

    Hi All, First time poster, long time reader. I have been having an issue with a formula I am inputting into the data validation widget to create a dynamic dependant dropdown error. The formula is as follows: =OFFSET(Setup[[#Headers],[Savings]],1,MATCH([@[Expense...
  19. S

    Pulling list of Unique Names from Refresh-able Table between Date Range (Or Month Number)

    Hello! Thanks for any help in advance: I'm attempting to create a "dynamic invoice" of sorts, with names being pulled from a "refresh-able" table. By that term, I mean an excel table that (I'm assuming) is pulling from an SQL query and just needs the "refresh all" button on the Data tab to be...
  20. L

    SUMIFS/INDEX-MATCH based on criteria in 2 rows and 1 column

    I'm using Google Sheets. In another tab, I'm trying to match in the values (in the white part of the table) based on the three criteria. So for example, I'm wanting to match in the 0.2856... for criteria: Member #1, 1, A.

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