index and match

  1. J

    Multiple Indexing/Matching and picking the Maximum Retrieved Value

    Hi All, I have a formula with 3 Index Matches, and I want to pick the MAX value of the retrieved results. It doesn't seem to be working...
  2. L

    Help me with Sumifs, Index and Match

    Good Day sir, I am creating some formula to make my calculation easier. However i am stuck. :laugh: In the Sheet 3 (with yellow mark) i want cell K6 and K30 have same value with K18. I already have formula in there, but idk what else i need to add. This sheet is working on how many job that 1...
  3. L

    Please Help me to SUM

    Good Day sir, I am creating some formula to make my calculation easier. However i am stuck. :laugh: In the Sheet 3 (with yellow mark) i want cell K6 and K30 have same value with K18. I already have formula in there, but idk what else i need to add. This sheet is working on how many job that 1...
  4. K

    Help needed to get whole column data as result by choosing a drop-down value in other sheet!

    Hi All I am finding it hard to get results in the following scenario: I have three worksheets Sheet 1, Sheet 2 and Sheet 3 In Sheet 1 I have a drop-down with values i.e. Team 1, Team 2, Team, Team 3 and Team 4. In Sheet 2 I have 4 Columns with the headings Team 1, Team 2, Team, Team 3, Team...
  5. B

    Need help to conditionally format a cell in one cell of a table based on the values of two other tables

    I am struggling with finding a way to highlight cells in my data preferably using conditional formatting in colour for sorting the following or flagging in some sort. My actual data source has about 8,000 people so manual sorting is not needed and I need to make sure I record each step for...
  6. S

    Nesting Iferror or Isblank into Index/Match

    Hello from downunder (Sydney), Im trying to create an item master from approx. 8 spreadsheets. All in different formats. Most have duplicate unique identifiers (SKU code), but some sheets have dirty incorrect data. Ive therefore determined a sequence based on the cleanest source. I am using...
  7. J

    How to get the value in multiple criteria of two columns ?

    I have data in Sheet1 and in Sheet2. I have three columns in Sheet1 Bank, Branch,Branch Code in A B & C column. In sheet2 I have Bank Branch Code in A B & C column In C2 of Sheet1 I want that IF A2 and B2 matches the criteria it will get the Branch code from sheet2 Range A2:C100. For example...
  8. M

    SOLVED: Index/Match, indirect... if my cell contains text, formula works; if it contains a number I get a #N/A - how to fix?

    Hello all, I am working with a somewhat complicated formula that seems to work when referencing cell values with text, but not when cell values are numbers...
  9. I

    VBA VLOOKUP or INDEX/MATCH returning #VALUE error

    Hi all, I'm having problems with some VBA script, and would appreciate any feedback on what I may be doing wrong - I've been using VBA for a few years but this is really beyond anything I've tried before. The relevant sections of code are below, and the scenario is this: I have a workbook...
  10. M

    Output based on multiple criteria/columns

    <tbody> Order Appple Orange Lemon None Null ProdType 1 Apple Apple 2 Apple None Null Apple 3 Apple Orange Multiple 4 None Null No ProdType 5 Lemon None Null Lemon 6 None No ProdType 7 Apple Orange Lemon None Null Multiple 8 Null No ProdType </tbody>...
  11. T

    Index and Match - with 2 criteria AND a date range...

    Hello, I have a doozy here and any and all help is truly appreciated. I am trying to create an Index and Match function that is looking for 2 criteria - a user ID and a date within a range. I have created this array that is looking for the user ID and the specific date...
  12. S

    Formula Help

    Hi Folks, I have this formula that finds one column of matches but I need a second column to also be returned. I need help in fixing this formula to allow the second column of matched info to be listed in column D if possible. Thanks Formula: =IF(ISERROR(INDEX('Analysis...
  13. C

    Reverse Copy/Paste using Index and Match

    Hello, I am self taught in excel and in the wonderful world of Macros. My question is that I am building a database with a data entering sheet. I want to use the index and match in a reverse form. That it would find the location in a table and copy and paste the data enter into the cell on the...
  14. L

    INDEX MATCH Formula help

    I'm working to get an index match formula to find a value in one table based on criteria in another. An example of each table is below, with my desired output being in the "Price" column of Table 1. Table 1: <tbody> Column A Column B Column C Column D Row 1 Thickness Type Width Price Row...
  15. S

    Array formula not calculating in linked workbooks

    I currently have a workbook with over 50,000 rows of data based on color, make, model, package, year and price of cars and I'm using an array formula to retrieve price based on multiple criteria. The formula works perfectly when all information is in one workbook, but the array formula does not...
  16. M

    multiple criteria match

    hi, I am trying to do an index match for 2 criteria. Lets say i have to return a random number from column C. Matching criteria 1 is DEF and matching criteria 2 is 01/11/2021 (I'd like to match the closest date). So ideally I would return Random(6). A B C ABC 01/01/2020...
  17. A

    Email VBA Using Index and Match from User Form

    I am trying to work with a User Form to send an email to my volunteers if they are a "No Show" selected on the User Form I have the code posted for the entire User form below, but the problem lies at the end with the email function. I am trying to use an index and match function using the name...
  18. A

    2D array lookup that can return multiple values

    Hello, I have a table of die numbers that correspond to another table of production numbers. I am looking to see if it is possible to automate the summing of the production numbers based on where the die numbers are. I will continue to use this in the future and don't want to have to sum the...
  19. T

    Entering Index Match Match using VBA referencing table sections.

    I have a macro that was running into issue mainly due to using the .select too much so I am trying to remove it from my code wherever possible, but I am unsure how to rewrite the following formula: Range("L9").Select ActiveCell.FormulaR1C1 = _ "=INDEX('Previous...
  20. M

    Formula to Calculate QTD and YTD

    Hi, I am looking for a formula to calculate QTD and YTD data. Brief explanation of my model, it will contain 3 years of actuals (2015-2017) and 1 year of current budget/plan data, all of which are broken out monthly. I will have 4 QTD calcs (actuals & plan) and 4 YTD calcs. I also have a lead...

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
Back
Top