index/match

Hello, I am currently working on a project to help declutter information and appropriate it with conditional formatting, that is obviously the easy part of this situation. However, I am curious to if this capability lies more in Vlookup/if formulas or if it is more of an index/match/sumif...

People Looking for a bit of general guidance here. In Col A I've got several thousand rows of data in the form of football team names. There are about 250 individual teams/strings in total. They all appear in Col A many times. I need to match each occurrence with their nationality in Col B...

Hello everyone, First of all, I would like to thank you for taking the time to help me out. Here is what I am looking to do: -I have a table with rate values for certain periods (dates) (Given) -Then I have another(second table) table that has three columns , start date input , end date input ...

When I use Index and match (instead of Vlookup) and sort the data, the row references do not automatically update (as they would in vlookup). This makes the function, IMHO, far less than useful. Why, why why does it do this and what can I do to make it stop? I have heard so much about the...

I have a list of withdrawals and within that list I have duplicates sometimes from the same dates. I want to put the withdrawals into an average per week (which I already have set up), but vlookup by itself will only find the first instance. This puts the duplicates into the averages of the...

Hi all, I have a value I'm looking up with an index/match formula, and the thing is this value also corresponds to data in another column that I'm also trying to pull. I want the data in those two columns to be reflected in my index/match statement Right now, I've got two very similar...

Hi, i am trying to build a macro code for a function that will replace the index/match function (trying to make it simpler. What i build: and how i want to apply it in excel is something like this (having this in a table so referencing @ a cell in the table that will vary depending on the...

Hello Excel Masters...I have the following index and match formula to find the "Daily_Total" value associated with a "Total_Date" value: =IFERROR(INDEX(DAILY_TOTAL,MATCH(B569,TOTAL_DATE,0)),AVERAGE(I539:I566)) I just experienced a first ... I have two "Daily_Total" values that are associated...

Hi all, I have two tables in a workbook. The first table has names and dates of birth (among other things) and the second table has names, DOBs, a few other things, and effective dates for an insurance policy. I'm trying to use index/match to check for a person by name/DOB and return "Y" if...

Hello, This is my first time posting so even though I read the rules, please forgive me if I accidentally break one or two. I am currently using excel 2013 and am trying to complete a lookup using Index/Match on two criteria. I am able to complete one row, but the formula does not...

Ok, so I'm good on how Index/Match works. I've used it successfully in the past, understand the examples that I can find online, I'm good. Where I'm having a problem is trying to incorporate a Max function. Here's my simplified data: <tbody> Cust Class Sales 1 Low 100 2 Middle 200 2 Low...

<colgroup><col span="4"><col><col></colgroup><tbody></tbody> <colgroup><col span="5"><col><col></colgroup><tbody></tbody> <colgroup><col span="2"><col><col span="2"><col><col></colgroup><tbody> 1/A B C D E F G 2 3 DATA TABLE Sheet1 LOOKUP TABLE Sheet 2 4 Price Qty Desired Qty...

Hello, Hoping to narrow down to a specific issue I'm running into: I am working with 2 sheets, a VIEW and PASTE. I paste time interval of data into PASTE, and use the following formula within VIEW to pull specific data, based on the interval the user selects (via a DV List) This is the...

I have a spreadsheet where I am working with DV, Index/Match and Offset. I am running into a problem, in that the formula is correct, and seems to display for some intervals, but not for others. Can someone help spot where I may be going wrong? The user will be able to select the time...

Hello, I have been working on this project, and thanks to the amazing help on this forum so far have been making some great progress. I am at a roadblock again, and hoping the great minds here can help. As mentioned, I want to grab the Scheduled From/To & Actual From/To for each agent, and...

Hello, I have raw data being pasted. I need a formula to use to extract data from the raw data into another spreadsheet. There is no common heading in which I can reference. Also, the array/range will vary, as the pasted raw data can be shorter or longer. The last thing is that within the...

Hi everyone, I ran into a pretty tricky situation here. I use Index/Match function extensively to match up two spread sheets. Our company has a coding system for materials to represent their different states. For example, we have "ABC?", to show unsorted ABC. And we also have "ABC-", to...

I have a lookup that Index/Match should perform nicely with the exceptions of a couple of wrinkles. I am consolidating income statement line items from a single store (unit) template. As I open new stores across periods, the I/S line items layer into the model. The line items change on a...

Hi all, please can anyone help with the following: In English I want.... a formula in Column K to search an array of columns (in only the same row)eg. Row20 and look for a value of "1" Once that value is found... I need K20(home cell) to display the info at the top of the column the "1" was...

I need a formula which will: Count the 1s in a column found using an index/match combination IF they meet two preconditions. Something like: COUNTIF(INDEX A2:BEB6000,0,MATCH("Bund"&"*",A2:BEB6000,0)) IF A2:A6000 = 0 AND IF (INDEX A2:BEB6000,0,MATCH("Q3"&"*"&"Bund"&"*",A2:BEB6000,1)) I have...