Get instant live expert help on index match multiple columns and rows
“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 a formula that uses index and match along with small, row and if statements to return multiple rows and columns of data from a matrix
Solved by Z. W. in 12 mins
I'm trying to Index Match, but need to look for a Match over multiple columns.
Solved by D. Q. in 29 mins
i need help with an index match formula which has to match a criteria across multiple columns
Solved by Z. Y. in 30 mins
Need help using array formula such as index, match or small to fill in cells that match certain criterias on rows and columns.
Solved by A. B. in 23 mins
INDEX MATCH Multiple criteria and output horizontally
Solved by E. F. in 24 mins