index/match

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

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

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

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

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

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

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

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

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!

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"...

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

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

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

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

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

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

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

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

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

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