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
i am trying to drag down an index search formula in sheet 1
Solved by K. U. in 30 mins
Can you please help me use an index match function
Solved by E. L. in 22 mins
I want to index match a cell, and have the conditional formatting show
Solved by V. D. in 15 mins
Need to total QTD numbers from an array. Using this formula =SUM(OFFSET(INDEX('HC Data'!$C$3:$P$17, MATCH($B40,'HC Data'!$B$4:$B$17,0),MATCH($A$3,'HC Data'!$C$3:$P$3,0),1),1,1-MOD(MONTH($A$3),3),1,MOD(MONTH($A$3),3))) works for 2 (i.e Oct & Nov of Q4 months but get an N/A on the 3rd month (i.e Dec of Q4)
Solved by V. J. in 23 mins
I have a column of figures. I have used the formula =MAX(RANGE), then LARGE(RANGE,1) in another column array of cells.. I now want to return the cell-addresses of those reference-figures, in cells adjacent to each reference cell. The formula CELL("address",INDEX($Col.$Row:$Col.$Row,MATCH(Reference Cell,$Col$Row:$Col$Row,1))) returns the address of the last cell in the column array no matter which reference cell it reads from.
Solved by F. L. in 26 mins
trying to index data based on date range to list on one sheet while the data indexing is located on multiple sheets.
i am able to index from one sheet fine, when trying to add multiple the formula breaks.
Solved by X. F. in 30 mins
Need help with excel index match multiple sheets. Index bills by due date on new sheet while data is pulled from multiple sheets.
Solved by C. C. in 29 mins
How do i implement an index match excel based on a drop down date selection
Solved by T. S. in 29 mins
I have a workbook with multiple worksheets. On one sheet I have linked cells to other sheets in the same workbook and used the $ in my formula to keep the row and column constant which has always worked for me pre-Windows 10. However, in my current workbook, when I insert a new line above the row with the linked cell, the destination cell formula changes to the row below the one I inserted.
I've looked online and have seen similar questions where the recommendation was to use INDEX or INDIRECT but INDEX is not applicable in my situation and INDIRECT results in at #REF! response. Did something with $ change in the latest version of Excel?
Solved by O. S. in 30 mins
Linking sheets, index formula and sorting. I dont mind how long it takes ...
Solved by Z. H. in 26 mins