Get instant live expert help with INDEX Function in Excel

I have a formula not working. =IFERROR(INDEX($AA$6:$BL$305,ROW(Z6)-2,MATCH($Z6,$AA$5:$BL$5,)),"")

In cell J10, enter an INDEX function that will convert the Call Day to the actual weekday found in row 1 of the DayofWeek named range. Resize the column width excel vba as needed.

I need to upload two files. Macquarie Recasted EBITDA is the OUTPUT file. The INPUT files are monthly .csv format income statements. I want to write an index match function to link from the OUTPUT file to all of the INPUT files and grab values that match based on single criteria.

I am trying to create an "Average" field to calculate the average of multiple columns in a pivot table (each column separately that is) knowing that the rows under each column will change according to slicer selection. I was able to create the formula to calculate that but i just noticed that once the reference word in my formula (which is "grand total") falls after row 99 then the formula gives no results !! here is the formula =IFERROR(AVERAGEIF(INDIRECT(B10&"15:"&B10&RIGHT(CELL("address",INDEX($A$13:$W$101,MATCH("Grand Total",$A$13:$A$101,0),1)),2)-1),"<>0"),"") any suggestion?

I would like the program names from column C in sheet 1 to be placed in columns AC, AD, etc in sheet 2. These programs should be placed in the columns of sheet 2 based on the rank they are listed for each person in sheet 1, column G. For example, person 1 should have program A listed in cell AC2, program B in AD3, etc in sheet 2. I think we are close and the formula I was given yesterday is below. But my actual data is contained on 2 separate sheets. Here is the formula: • =IFERROR(INDEX('Text worksheet B'!$B$2:$B$500,MATCH(1,($A2='Text worksheet B'!$A$2:$A$50)*('Text worksheet B'!$D$2:$D$500=COLUMN(M$1)-COLUMN($L$1)),0)),"")

In cell B6, add an INDEX function that will use an INDIRECT function to retrieve the department issue list for the department listed in cell B3. Use an absolute reference to B3, and then use a relative cell reference to A6 as the row_num argument. Copy the formula down to cell B9.

In cell H12, add an INDEX function that will use the Dept named range as the array associated with a MATCH function to determine the lookup array for the longest call referenced in H11 from the Call_Length named range with an exact match. In cell H13, add an INDEX function that will pull the satisfaction rating associated with a MATCH function to determine the lookup array for the longest call referenced in H11 from the Call_Length range with an exact match.

I was sent a spreadsheet and have a #NAME? error. I have no idea how to fix this and tried the Excel Help Error button which provides no assistance. The formula is: =IF(COUNTA(INDEX('Ad Copy Builder'!F:F,A8+1))>0,_xlfn.CONCAT(INDEX('Ad Copy Builder'!B:B,A8+1)," | ",INDEX('Ad Copy Builder'!D:D,A8+1)," | ",INDEX('Ad Copy Builder'!F:F,A8+1)),_xlfn.CONCAT(INDEX('Ad Copy Builder'!B:B,A8+1)," | ",INDEX('Ad Copy Builder'!D:D,A8+1)))

I need help with this formula: =IFERROR(INDEX(Sales,MATCH(B22,CustID,0),MATCH(C22,SaleMonth,0)),IF(B22=0,"Must enter ID number FIRST in the merged cell B22",IF(7=ERROR.TYPE((MATCH(B22,CustID,0))),"NO RECORDS FOUND",IF(OR(AND((MATCH(B22,CustID,0))>0,C22=" "),AND((MATCH(B22,CustID,0))>0,ERROR.TYPE((MATCH(C22,SaleMonth,0)))=7)),"Acceptable Month values ARE April, May, June - case not important"))))

I am trying to use index and vlookup unsuccessfully!