Get instant live Excel expert help with INDEX MATCH Function

“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 need help pairing multiple index match formulas in a large, complex sheet. Please help me!
Solved by F. A. in 22 mins
Hi, I am struggling with INDEX MATCH formula. Please can you help?
Solved by I. U. in 30 mins
How can I shorten my nested if and index match statements to be bale to run on a recorded macro?
Solved by T. C. in 28 mins
I need to use 2 index match matches in one formula tab. I want to return the ordered quantity of an item based on the product code and size. But the sizes range is across 4 rows, rather than a single row match. Is this possible?
Solved by O. Q. in 14 mins
I have hundreds of rows/columns of data that I need to organize into one row per "issue." The raw data pulls data into multiple columns and rows, but I am trying to find an Index Match, or another formula that will put all data related to Issue #X into one row, recognize a blank row from the raw data, and put the next group of data into the next row.
Solved by C. Y. in 20 mins
Table 1's data is in A5:M603. I need a value to populate in C2 from Table 1 Column G if the value entered in A2 matches a value in A5:A603, and if the value entered in B2 is greater than the value in B5:B603 and less than the value in C5:C603. I've been trying some Index Match formulas but nothing's working. Please help! Thanks.
Solved by V. L. in 26 mins
I am trying to use a vlookup or index match but cant figure out how to do it whilst matching two variables.
Solved by D. E. in 18 mins
How do I stop this N/A error on an Index Match Formula?
Solved by B. W. in 27 mins
I need to use INDEX MATCH or some other lookup formula to return data from a raw data table into an organized sheet in the same workbook.
Solved by B. C. in 18 mins
I need help doing a vlookup or index match between two excel sheets. I really need a way to find and delete info with ease.
Solved by Z. Y. in 16 mins