index/match

  1. G

    Index / Match multiple criteria and multiple results

    I have a spreadsheet using the following formula but I found that some users of this report are on Excel 2016 and cannot upgrade so I have to use something older like Index / Match to mimic these results...
  2. R

    VLOOKUP or INDEX/MATCH Question

    Hi all, I am looking for some help with the below table today. This is sample data that represents some real data that I have. The dollar amounts represent payments that have been made and $0 amounts indicate that no payment was made. What I want to do is be able to find the date of the last...
  3. P

    Quicker way to process more than one row using Index Match

    Hi, I have the below base data that I want to split in to individual sheets. So that each ID has its own sheet. ID heading is in cell A1 ID Name Detail Date 1A Joe Arm procedure 24-Mar 2A David Leg procedure 12-Feb 3A Sarah Shoulder injection 01-Apr 1B Hannah Knee Pain 03-Feb 2B...
  4. J

    Index/Match and Concatenate

    Hello: I have a list of first and last names and amounts in a range. I want to find the amount that corresponds to both the first and last names and return that value. I've used Index/match in the past when there was only the last name and it worked fine. Now, when I added the first name, I...
  5. J

    Pulling from a Vertical worksheet and goes to a Horizontal Spreadsheet

    I am trying to pull information from a Vertical worksheet and put into another worksheet. This is what I have been doing for the past year, but it is time consuming changing the row numbers of the people. =HLOOKUP($B53,'S:\Corporate\Loss Prevention\Schedules\2019\[Southeast.xlsx]Data...
  6. D

    Index/Match in 2 data tables

    So Index/Match is a great tool but I'm having a hard time wrapping my brain around this... I want to return a field called "Date" to "Table1" from "Table2" using a common field of "Ticket" but i keep breaking things.. Kind of like a Vlookup but without the first column restriction... Thanks in...
  7. M

    INDEX/MATCH with Return Numbers Only

    The following INDEX/MATCH formula works but, I would like the return to be just the numbers (no text). Help modifying formula would be appreciated. =IFERROR(INDEX('SDC TRIRIGA'!$C$1:$C$15000,MATCH(A2,'SDC TRIRIGA'!$A$1:$A$15000,0)),"") Current Return: <tbody> REQ-1187706 </tbody> Would...
  8. C

    Index/Match not working

    Morning all, Apologies for the second Index/Match query this morning... wasn't sure if piggy-backing onto that thread was allowed! I would like the formula to look at two separate cells in one worksheet, compare them to columns A and C in a second sheet and return the value in column E... I...
  9. T

    Index/Match Partial Match

    Hello, I have the formula: =IF(INDEX('4WK MVT'!B:B,MATCH('Worksheet'!C12,'4WK MVT'!D:D,0))="*"&"DC"&"*",True,False) The end goal here is if the returned result has "DC" in it, I want it to the True, if not, False. Pretty sure I am using the wildcard incorrectly or something. Thank you!
  10. T

    Index/Match with OR Function

    I need one of my match criteria to be an or statement. I am currently using the below =INDEX($I$37:$I$1128,MATCH(1,INDEX((D37=$D$37:$D$1128)*(F37=$F$37:$F$1128)*($G$37:$G$1128="Base"),0,1),0)) I want the last set to look for "Base" or "Allowance"...
  11. H

    COUNTIFS formula with INDEX/MATCH column

    Hi All DataWork Column Q contains INDEX/MATCH formula results, am I right in thinking that is why this formula returns a count of zero? Many thanks
  12. I

    How to compare two sheets of data for matches?

    hi all. curious what the best method for comparing two sheets of data. essentially, i want to see which data in Sheet A turns up in Sheet B. there are 3 columns (A,B,C) of data with matching parameters in both sheets that i would want to make sure align. is an index/match formula the best...
  13. S

    Index/Match for Nonblanks

    Hello Everyone, I'm designing a sheet that is to be used as a tally for a strawman poll before a real vote is held on some projects being considered at my company. Some of these polls will have comments on them when returned. I'd like to list all comments, though most will be blank with no...
  14. K

    Index/Match in VBA with criterion applied

    Hi everyone, First time posting so apologies if I commit any faux pas. I have a classic problem with vlookup whereas I have multiple matching values but want to get a specific index. I recently got into VBA and wrote a function which does the following: In sheet 1 Looks if cell value is equal...
  15. M

    INDEX/MATCH & SUMIF (with one and/or two comma separated reference numbers)

    Hello All, The following formulas work with a single reference number in a cell. The issue is that some cells contain two reference numbers separated by a comma (example: 123, 345). How can I modify formulas to account for one and/or both reference numbers?. Any help would be greatly...
  16. B

    how to find if any unique values in two columns for each value in one column

    I have two columns. column A has text, column B has a numeric ID. A B Pizza 40 Candy 20 Soda 30 Broccoli 20 Pizza 40 Every time "40" appears in column B, I want to make sure that all the respective values for 40 in column A, are the same. In this case...
  17. M

    Index/Match: Value Return with additional text in front

    Hello All, How do I modify formula below to return value with "Description:" in front? Example Value Return = Description: Cooling System Replacement =IFERROR(INDEX('Report'!R:R,MATCH(A1,'Report'!A:A,0))&"", "") Regards, Morey
  18. M

    Index/Match question?

    With the following example; APRIL 500 MAY 550 JUNE 700 JULY 800 The above months are text rather than a date entry. In cell E1 I would enter a text month name. I need a formula that sums the data above for all rows starting April, up to the row matching the entry in...
  19. K

    INDEX/MATCH Query - Amendment needed

    Hi all, I have this formula below which INDEXs a list for every date of the year vertically G4:G369, I then created a match for the column next to the date so if the cell has a H, it returns the date from the INDEX range...BUT it keeps returning the same duplicated date over and over when I...
  20. K

    VBA Index/Match to Fill Right and Down

    Hello, I have a tab [consolidated] and a tab [adhoc]. I am trying to develop a dynamic formula in [consolidated].F2 to do an Index/Match to the [adhoc] tab and extract a bunch of data. This is super easy without VBA. By writing the code as I do below; this allows me to drag the formula to...

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