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 need help with index match with changing column but getting error
Solved by E. D. in 30 mins
I need help with index match formula when I drag down shows N/A tried to put IF ERROR = "" doesn't seem to work
Solved by F. A. in 16 mins
Can you tell me why my Index Match Formula is returning #N/A?
Solved by B. L. in 17 mins
i need help with an existing index match formula it picks up value from the start of the month I want it pick up as midmonth
Solved by F. Q. in 22 mins
I have two worksheets, one with data and one for excel offset match, lookup, Index, Count functions. I need the data sheet to go to the lookup sheet and return values based on criteria in the data sheet.
Solved by F. J. in 18 mins
I need to determine "Eligibility" based on Household value, and annual income reported, with a given parameter. I was suggested to use an INDEX MATCH MATCH formula but I cannot figure it out.
Solved by S. L. in 30 mins
I need some help in amending an index match example
Solved by B. L. in 26 mins
I'm trying to have a cell spit out a number by counting the number of times a name in a column occurs matching a specific date using INDEX(MATCH()). There's a separate cell where I can type the date and the count will dynamically give me a different count based on that date.
Solved by Z. L. in 18 mins
I need to help in changing an index match formula into a sumproduct formula
Solved by A. E. in 12 mins
I need help with a index match formula which needs to be changed
Solved by G. W. in 12 mins