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

using index match, i am getting values that are for similar names but not exact
Solved by I. Q. in 16 mins
I have the responses from an excel form that feed into the excell workbook which contains worksheets for each individual that reports their data in the the form. I'm trying to get it to pull the data for each individual into their worksheet from the responses tab. I thought I had it figured out using INDEX MATCH MATCH for one of the individuals but the same formula wouldn't work when I tried it for another individual.
Solved by O. J. in 27 mins
I have the responses from an excel form that feed into the excel workbook which contains worksheets for each individual that reports their data in the the form. I'm trying to get it to pull the data for each individual into their worksheet from the responses tab. I thought I had it figured out using INDEX MATCH MATCH for one of the individuals but the same formula wouldn't work when I tried it for another individual.
Solved by I. W. in 26 mins
I have a problem regarding to Sum range with INDEX
Solved by G. S. in 19 mins
Hi how can I use index match to find the delivery date column H
Solved by X. E. in 27 mins
I WANT index and match help get the target as per the option selected by drop down. also i need to lock the scroll which wil no get change in other computers
Solved by A. A. in 18 mins
I need a formula that would choose one array to index if it matched one cell or choose another array to index if it matched another cell. Basically I am trying to get pricing out of an array for regular customers and preferred customers. The formula I would use if I was only choosing from one array would be =index(shipping, $P3,$N3) I want to reference the cells in column Q in order to then reference the correct shipping price array.
Solved by O. C. in 20 mins
whats the best way to make match in excel formula work by adding new rows of information for the formule in the spreadsheet
Solved by S. W. in 18 mins
how to calculate foreign exchange variance from historic and live rates choose or index match
Solved by S. A. in 13 mins
How to make a match formula in excel to stop reading after intended critieria is met
Solved by X. H. in 19 mins