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

I have created a small test sheet to check that the excel INDEX MATCH formula is working as I need it to. It seems to mostly work but randomly returns the wrong postcode for a couple of rows. I have highlighted this postcode in yellow on the lookup column and in green on the return column. This should match without issue like the other values that work fine (I dragged the formula down from D2). But for some reason the wrong postcode is being returned (highlighted in red).
Solved by A. H. in 12 mins
Im thinking I need to use an excel index match multiple results but I want it to search through multiple columns and return values that aren't 0
Solved by E. H. in 11 mins
Without using an index match formula could you please extract all the sodium results for each patient and make a table of them
Solved by T. E. in 19 mins
• Use this range to draw 5,000 random samples from the probability distribution you created in Question 1…. (i.e. with the OFFSET() and MATCH() functions (or INDEX() if you prefer))
Solved by A. B. in 12 mins
If I have one cell with a number in it, how can I have the cell next to it refer to that cell. For example, if I record someones BMI (body mass index) as 22.5, can I automatically have the cell next to it refer to what this means using words, e.g. normal weight, underweight ect?
Solved by D. A. in 13 mins
What I’d like for you to do is: On the Invoice Print tab: Column A - starting with Cell A18 there is an index formula that pulls unique values from the Wine & Spirits Supplier tab, which are then used to fill in information in columns B through L – please correct the formula so columns B through H return correct values Add formulas in column J and L to calculate scanned units and total $$
Solved by M. H. in 27 mins
trying to use index match formula to pull information but i have repeated items I am trying to match
Solved by T. J. in 24 mins
Hello, I have a complicated multiple if statement that requires the use of an index match excel function to find the the closest value.
Solved by Z. S. in 13 mins
I'm trying to reference report data into a linear time line plan based on values in in a row and in a column. Tried if statements and Vlookups but have a feeling it may require Index and Match functions
Solved by S. A. in 22 mins
I need help with referencing a set of data into a plan. MATCH or INDEX functions?
Solved by G. U. in 20 mins