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
Hello,
I am working with two workbooks. I am trying to get specific information from one onto the other using 3 criteria. I currently using a index match formula. Both sheets have the same information but one has a response that I am trying to match and populate onto the new report. However, instead of looking up the actual value of the cell - its matching the location and giving me whats in that cell.
=INDEX('[Arrow OOR - 9-11-18.xlsx]Response'!$A:$L,MATCH(1,(A:A=A4)*(B:B=B4)*(F:F=F4),0),12)
Solved by I. C. in 13 mins
I need to find an INDEX function that will convert the Call Day (a number 1-7) to the actual weekday found in row 1 of the DayofWeek named range. I don't know if I'm supposed to use the MATCH function as well or not.
Solved by D. D. in 16 mins
I'm having trouble with an index & match formula where I'm looking up two different pieces of info in order to return a specific value.
Solved by K. D. in 21 mins
I need a formula that looks for a specific name in three columns, takes all of the rows that match to get dates from another column. Then from the dates that match the rows with the names, take the second earliest date and generate it.
The below formula is giving me the second date listed for the specific person instead of giving me the second earliest date.
=IFERROR(INDEX('Input Data'!$E$5:$E$150,SMALL(IF(Tracker!$B6='Input Data'!$G$5:$I$150,ROW('Input Data'!$G$5:$I$150)-ROW('Input Data'!$G$5)+1),2)), "N/A")
Solved by A. J. in 23 mins
Conditional index on both rows and columns, with automatic filling by drawing
Solved by T. J. in 21 mins
index,indirect,match,hlookup,different sheets,drop down lists,different tables sizes,buttons
Solved by G. H. in 15 mins
Two criterias index from rows to columns, matrix cordination
Solved by F. Y. in 29 mins
I need help with an index, match, match function. I am trying to return the values in column 'CT' on the 'DATA' sheet (coloured purple), for the appropriate year and veg type, on the 'CALCS HRZ' sheet, column Q (Coloured pink)
Solved by M. Y. in 29 mins
Click cell C21, start an index in excel, and select the first argument list option.
e. Choose the Responses range for the Array argument.
f. Click the Row_num box and nest a MATCH function. Select cell B21 for the Lookup_value and
cells A3:A28 on the Mailings sheet for the Lookup_array. Click the Match_type argument box
and type 0.
g. Click INDEX in the Formula bar. Click the Column_num box and nest a second MATCH function
to look up cell D3 on the Mailings sheet in the lookup array A3:D3.
h. Click the Match_type box and type 0
Solved by C. F. in 22 mins
MY index match is not working. It has to do something with the value from the pivot table. If I type in the number my index match works, but if i take the same number from the pivot table it does not work. Has to do something with formatting I believe but cannot figure it out.
Solved by M. W. in 12 mins