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

hi how r u doing ? need help on sheet to add index match and indirect function
Solved by D. B. in 14 mins
hello need some optimizations on sheets and add indirect and index match function
Solved by G. Q. in 12 mins
lookup using index match match, but with a couple of wrinkles
Solved by T. J. in 20 mins
i need help with index match match, with a few wrinkles. i was online with an expert about 1.5 hours ago, but i had to end my session
Solved by A. Q. in 22 mins
I need help with an index match formula in excel as part of the formula is working but this requires an additional parameter I am not sure how to code
Solved by X. W. in 28 mins
I need assistance creating a fairly advance index match function excel for multiple variable criteria
Solved by E. J. in 30 mins
Advanced Excel function: index vlookup, if then I have a two tab worksheet. Tab one contains two columns, first and last name, the second tab contains first, last name, and a total. I have tried to use a concatenate function to compare, however it failed. I need to compare the name and place a total on tab one if it is a match. Vlookup works, but if the first name is incorrect that proves a challenge.
Solved by S. F. in 19 mins
need help with index match to merge data from multiple sheets in one and it should get auto populated from sheets when i add another rows there i dont wether this is easy or not but i have tried with many sites it was not done ever please help me with this
Solved by S. H. in 11 mins
I have been attempting to use the index match function excel to pull the task from the cell below the current day in the month sheet into the first tab, which is the "upcoming 7 days" sheet. Ideally, the tasks cell in the "upcoming 7 days" sheet should auto fill what is listed in the monthly calendar sheets.
Solved by V. Y. in 25 mins
Need help with this excel index match example. I want to have an index match formula, return values in sheet 2 column given date, into sheet1 A2
Solved by K. Q. in 16 mins