Get instant live expert help with INDEX Function in Excel

Hi I have a large data set with two column headings.The top heading is what the table shows e.g number of staff or turnover, and the second row is the month but the months repeat under heading above (Effectively lots of tables next to each other). The row headings are locations. I am trying to create a graph with changeable parameters using a drop down menu. One graph in one place that shows all our data e.g location 1 turnover over the year and then be able to switch it to location 5 staff numbers. I'm trying to use index match but can't work it out

Hi there.. I'm trying to use my existing formula to check multiple sheets for 'yes' in a certain column. This formula works perfectly for 1 sheet (jan),.. but I need it to check everything month (each month per sheet) and then load the row. formula: =IFERROR(INDEX(Jan!A$4:A$250,SMALL(IF(Jan!$M$4:$M$250="yes",ROW(Jan!$A$4:$A$250)-ROW(Jan!$A$4)),ROW(1:1))),"")

My Index formula is not returning the Team Name into the cell - I am getting the #NA Error.

My index formula is not drawing the name into the necessary cell.

i want to do an index, match search. one of the criteria i want to match is a date which is formatted as MMM-YY (Worksheet "Index Returns" Cell $C$1) against a column of dates formatted as 1/01/2017 (Worksheet "BSG_Subj_RTN" Cell $A$266). If the formatting were reversed, I would simply take my numeric date and translate it to a 'text'... but I do not seem to be able to take a column of numeric dates and covert them to a text. What do you recommend?

Spreadsheet attached: I want to use Index, Match to find the appropriate benchmark values for a given date. My problem is that the date I am searching for is formatted as: MMM-YY and the column I need to search is formatted: 01/01/2017. The spreadsheet I am working with is attached. the first worksheet ("Index Returns") I am trying to fill with values from BSG_Subj_Rtn. If the formats were reversed I could search using Text ...but this does not seem to work when searching an entire column. Any thoughts would be very much appreciated.

See attached Workbook. I need to fill in the blanks on Sheet("Index Return") with data from Sheet ("BSG_Subj_Rtn"). Let's look, For example .. in Index Return Sheet: I need to find the value of cell C6 or the performance for the MSCI Eafe Index Net for January 2017. On Sheet BSG_Subj_Rtn, this value is Cell J814. I think I need to use an Index...Match formula but I am finding issue with this because the Index range is not contiguous (A1:j1, A550:j823) and I have to compare a date configured as MMM-YY with one 1/1/2017. This is something that is downloaded from a 3rd party source monthly - so if I can avoid adding columns to BSG_Subj_Rtn to do this search, that would be preferable. Any thoughts much appreciated. Thank you in advance

I have 2 worksheets. I need to figure out how to search for the date in cell $c$4 in "Index Returns" in worksheet "BSG_Subj_Rtn Column A . The first is formatted Jan-17 and the column I am searching is formatted 1/1/2017. Second question. Can I search a noncontinuous range? In otherwords, if I wanted to search BSG_Subj_Rtn using the header row (A1:J1 and data A:550:J823)... using Index...Match. is that doable?

need help with a vba macro that i have Sub CF_Applied() 'create key index Range("K2:N5") sr = 2 sc = 11 Key = "" For r = 0 To 3 For c = 0 To 3 x = Cells(sr + r, sc + c).Interior.ColorIndex If x = -4142 Then x = 0 Else x = 1 Key = Key & x Next c Next r 'the above defines the range for the Key (Mask) to match sc = 5 For l = 2 To Cells(Rows.Count, "E").End(xlUp).Row Step 7 key1 = "" For r = 0 To 3 For c = 0 To 3 target = Cells(l + r, sc + c) Z = WorksheetFunction.CountIf(Range(Cells(l, sc), Cells(l + 4, sc + 4)), target) If Z = 1 Then x = 0 Else x = 1 key1 = key1 & x Next c Next r If key1 = Key Then Cells(l, sc - 1) = "Match" Else Cells(l, sc - 1) = "" Next l End Sub

I'm having an issue with an "index" formula. Can you help?