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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am trying to use Index and Match to return the first date something was billed. Conversely, eventually I need to find the same for the last date. Right now, I am using a simple index match based on the row number, but if the activity changes, I need to validate the activity on Sheet 1 with the description on Sheet 2. There needs to be some logic in the formula to match the description to ensure it is looking up the correct row. Thus the logic would be, lookup/match the description in column A, then lookup and return the corresponding date for the first column within the corresponding row with a dollar value in it.
Solved by M. A. in 29 mins
I'm trying to figure out how to construct a nested Match function within an index function.
Solved by A. L. in 25 mins
I tried to do an array formula but it won't take data from another worksheet in the workbook. Current formula is =index('Daily Report Log'!A9:A23, Match("*CFT*",'Daily Report Log'!M9:M23,0)) which I get the 1st date reference BUT not any other dates after. I'm currently using INDEX MATCH - which simply returns the first match ONLY. But there are multiple matches, that need to be listed. I need to see multiple matches listed. The data is coming from another worksheet within the workbook. Not on the same page.
Solved by F. H. in 24 mins
I am trying to find the maximum vale in a column and its index.
Solved by I. H. in 29 mins
need help with excel match index function to up date information as I add more data weekly not having to adjust every single formula.
Solved by X. Q. in 11 mins
How combine 6 tables in one table i was using 2 tables combine in one table sucessfully. but 2 more than table I cannot possible. I am Using formula table 1 Fruits Apples Oranges Pears TABLE 2 Fruits Grapefruit Oranges Cherries Melons i using formula is =IF([ItemNumber]<=ROWS(List1),INDEX(List1[Fruits],[ItemNumber]),INDEX(List3[Fruits],[ItemNumber]-ROWS(List1)))
Solved by B. J. in 15 mins
trying to build this dash board, but there is there is a formula that i cant get to work. not an expert in excel but im trying to learn on the making of the report. the technical problem is adding data and to show the addition in another sheet using index and match.
Solved by Z. H. in 19 mins
0 down vote favorite I'm fairly new here and i would like to use help of all excel experts here. So I've run into a problem at work. Situation is I have a table: Row labels: Course names columns labels: Job positions and further sub divided into new and Existing employees. And cell values contains "Yes" for each column and row based on if that job description requires that course, there are more than one courses for each job description. So I want make a another table by getting a values out of above table basis of "Yes", and I want to list the courses by job description. For Example: job Description Courses Clerk courseA Clerk courseB Clerk courseC I have been trying index and match function to get values but not getting any success.
Solved by B. U. in 14 mins
I am using phpexcel which does not support some formulas like iferror so I am converting my formulas from iferror to if(iserror(),"","") but I am not able to convert this formula. Can you please check and convert it for me? {=IFERROR(INDEX($Comp.$A$1:$A$45,SMALL(IF(($Comp.B$1:B$45=1),ROW($Comp.$A$1:$A$45)),ROW()-ROW($Comp.A$51)+1)),"")}
Solved by Z. Y. in 27 mins
Hi, I am having trouble with index and match. i have one colume for index B but need to match over a number of different colums J to U. i have goten this far and i tryed many different variations currently =INDEX(B2:B40,(MATCH(E1,J2:J46,(MATCH(E1,K2:K46,0))))) this retuns the correct index but seem to jump over J =INDEX(B2:B40,(MATCH(E1,J2:J46,0))) works but i need to sherch over colunms J to U please help
Solved by K. Y. in 22 mins