index match

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. G

    ISNA or VLOOKUP (DATE) or VLOOKUP (NUMBER)

    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)...
  7. 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...
  8. 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...
  9. 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...
  10. 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.
  11. L

    SUMIFS with 2 row and 1 column Google sheets

    I'm trying to match in a value (either using SUMIFS or INDEX MATCH) based on multiple criteria (two rows, one column).
  12. J

    Large Formula with Index Match by Criteria

    Hi, This is the first time I've posted here so apologies if any of this is incorrect. I have a list of products ordered by week with their volume. I would like to select the top ten products by week. I have found and used the formula which gets the top ten, but I am struggling to do it by...
  13. T

    IF/INDEX/MATCH Formula

    Hi guys, I'm running into an issue which I'm hoping someone might have a solution. For some reason, the INDEX/MATCH formula will not pull in the correct result if it's in %. For example, the IF/INDEX/MATCH formula on Sheet 1 is pulling info from Sheet 2 and the answers could be: Not...
  14. W

    Index Match Madness

    This is the first tab ("All Hours"). Column B is color coded based on the category in tab 2 ("Reg WHSE Billing") I've searched everywhere to attempt to learn the index/match formula to try and get this to work and it's been a miserable failure. The second tab needs to look at the employee name...
  15. J

    Ifs Statement

    I am trying to get an if statement to work in where 1. if cell = text refer to another cell 2. if cell = text refer to another cell 3. If cell does not have either text then index match... The first two are working fine. The third is giving me a value error. If anyone can help! =IFS(I241="b /...
  16. K

    Lookup Approximate match against multiple criteria!

    Hello Everyone, I have a data table and i want to find approximate match against that table, CATEGORY DENIM DENIM NON_DENIM NON_DENIM RANGE NORMAL WASH HEAVY WASH WASH DYE 999 8.00% 12.00% 8.00% 12.00% 2,999 6.00% 8.00% 6.00% 8.00%...
  17. A

    Match Index? How to split a saving value across 12 months based on month of saving realisation and other controls

    HI, I am trying to create a savings log which would enable us to detail down the savings we generate as a business. Essentially the main issue I am facing is that I can dedicate fields to detail the saving total along with a date that can be used to identify a realisation month for the saving...
  18. L

    Find related items based on multiple criteria > index+match multiple criteria or somthing else?

    Hi all, This is a challenge, at least for me. What I'm trying to achieve is the following: I've a big list of items with several specs. I want to project the matching items (with the same specs) in columns after the item to match. Simplified example of the data: <tbody> Item Spec 1 Spec 2...
  19. M

    Index Match Match.... It just wont work :(

    I am an avid VLookup user and have recently learned of all the benefits of Index Match and Index Match Match.... I just cant seem to get it to work on my workbook! I would be extremely grateful if someone would be able to help me. On tab named 'Database' I have a table of data in cells A4:EV7...
  20. G

    Index Match with Right Function

    I have an index match that gives me results for prices with a string of text I want to remove. Example: USD 41.99 In a separate cell I have the RIGHT function to remove the "USD ", but I would like to have a single formula in one cell...

This Week's Hot Topics

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
Top