index/match

I'm looking for an Index/Match formula that will compare 3 cells and pull all cells that have that specific date listed in it. What's the easiest way to go about this?

Hi everybody, I have the below index/match formula which works in looking up values from worksheet2 that are on worksheet1 and returning a final match. Problem is I'm looking to add this to some VBA which will create a large number of worksheets, so I need the formula to calculate based on, for...

Hello, I'm having trouble with vlookups and index/match in a table. I explained the vlookup issue in this post "VLOOKUP Only Returning Some Values otherwise #N/A but Index/Match Works". It seemed like index/match would work but one row out of a a couple thousand did not work. I'm very familiar...

I have data from different campaigns in separate sheets [per market]. Actual data is five sheets but in the dummy data, I've only worked with two sheets. In a summary sheet, I want to be able to find the correct value for Sessions in column I of 'Email Sends' sheet. This should check for the...

Hello, I am trying to create an Index/Match (open to other suggestions) that would return information from an array that was based around a few conditional matches. In the example below: John Smith has pay/deductions assigned to Department 200 and 201 (rows 2:7 are for Dept. 200, rows 8:15...

Hello, I am looking to create an Index/Match (open to other suggestions) that would based on a specific section of cells based on a conditional match. In example below, John Smith has pay/deductions designated to Department 200 and 201. If I'm looking for the Tax 2 amount for John Smith in...

I will be grateful for help with the following I have an array in the following manner: 31/01/2018 28/02/2018 31/03/2018 30/04/2018 31/05/2018 30/06/2018...... First 120 0...

Hi, I keep getting an #ref error when trying to populate the left matrix with data from the right table (located on another worksheet). I am using the following in b2:=index(j:j,match(b1,h:h,0),match(a2,i:i,0)) and that yields the #ref error. Any advice? Excel 2016 (Windows) 32 bit...

Hello! I am using Index/Match and in the value to be matched, I want to specify the value of a cell +/-5%. How do I specify that? thx!

<tbody> <tbody> =LEFT(C1,4) 2012/2013 DEC Montana =INDEX('Sep Corn Stocks'!$A$2:$T$53,MATCH(1,'Sep Corn Stocks'!$F$2:$F$53=Corn!B3)*('Sep Corn Stocks'!$B$2:$B$53=VALUE(TRIM(CLEAN($B$1)))),20) North Dakota =INDEX('Sep Corn Stocks'!$A$2:$T$53,MATCH(1,'Sep Corn...

Hi all, I need some help regarding Index/Match as I'm not sure why this isn't working. <tbody> A B C 1 Jan Feb Mar 2 30.2 40.2 60.0 3 5.4 15.1 90.1 4 30.1 40.5 50.3 </tbody> in the table above, I want to output which Month has the largest value (so in this case, my output should...

I am trying to recreate much of a clunky spreadsheet that suggests item numbers for products that didn't have item numbers. One calc performed in Excel is an Index/Match within same table. I ultimately have some choices for a number in earlier columns, but when I run out of choices, I try to...

I have an issue when using index/match formula in excel and some cells are deleted. I fill row A and B automatically (first name and last name) with index/match formula depending on a employee ID on C column. C,D,E columns are automatically populated (data > import from table) that is stored on...

This index/match works perfect: =INDEX(Plan!AR:AR,MATCH(A:A,Plan!AR:AR,0)+1,1) I am looking up a sku number in ColA that exists in ColAR, but it's always 1 row below ( hence the +1 ). Next one that doesn't work for me: I want to look up same exact sku(ColA) in ColAR, but then look for a...

Hi All, I need some help with constructing a formula. Basically I have a three column table, one column is transfer document, one is shop and one is goods code in the shop. What I'd like to see is what is the goods code of the same goods in the different shops. The only connection between the...

I have a list of data and i'm trying to extract info from the list using an index/match formula. This is working but only until I change one of the drop downs from the 1st option to the next and then the answer for the formula is coming back #REF . I think somehow I need to incorporate the other...

I need to find a formula that returns the bold number when 1 happens <tbody> 1 2 3 4 5 6 7 8 9 10 0 0 1 0 0 1 0 0 1 0 </tbody> So my goal would be to return in separate columns: <tbody> 3 6 9 </tbody> I was thinking about index/match - but in this case it wouldn't work, but maybe...

i mean, in sheet1 i have this: in sheet2: in sheet3: my question is: how can i use index/match across multiple sheets (even when new sheet is created, possible?) at sheet1 A1 (i have thousand lines in B column in reality)? thank you all

I have a table like the below, trying to find top 5 attendances using LARGE then INDEX/MATCH The issue I have is that in GameWeek1, two teams have the same attendance therefore the INDEX/MATCH brings the first one back twice. For example, in G1:G5 I have the numbers 1 to 5. In H1:H5 I have...

Hi there, I'm having an issue related to how long a macro takes to complete. Originally my code used a significant number of WorksheetFunction.Vlookup formulas to pull the data I required into my Allocation Sheet. After doing some reading/testing it seems that my code below is now a slight...