Get instant live expert help with INDEX Function in Excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
In cell H10, enter an INDEX function that will use a nested INDIRECT reference to the Dept named range listed in column C (C10), and use the Reason field in column B (B10) as the row number to return for the department name in the referenced named range.
Nest the function inside an IF function so that issues currently displaying as a 0 will display as a blank cell. Resize the column width as needed.
Solved by Z. W. in 30 mins
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 as needed.
Solved by M. H. in 24 mins
On the CallCenterReport worksheet, add formulas that will summarize the issues for the department entered in cell B3,
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
Solved by F. H. in 15 mins
In cell H11, add a MAX function that will show the maximum call length minutes using the Call_Length named range and 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.
Solved by V. J. in 18 mins
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.
Solved by I. W. in 16 mins
Hi I need help. Can you give me an excel index match tutorial
Solved by S. B. in 26 mins
I am trying to do an index match with a If qualifier. Specifically, the data in any one month is dependent on the original start date and the month in which an annual increase takes palce.
Solved by T. U. in 19 mins
I need to use two match criteria when do excel index match example
Solved by T. D. in 30 mins
I have an excel Index Table in A1 to A10. The topics are mentioned below in the same sheet. How to refer that. For Example I have a topic in Cell A1. If I click the topic in A1 it has to take me to A15 (Where the topic is explained). How to make a reference like this?
Solved by S. C. in 30 mins
Can you please teach me how to use index match function?
Solved by B. D. in 23 mins