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

So here is my issue. I'm using excel to calculate out the debt service that I need to support a hypothetical development, and the sumif function doesn't seem to want to work given the formulas I've setup. So the debt service is a basic amortization table debt service table over 25 years. But for the development I only need to be worried about the debt service on the loan through the period that I'm doing the development. In this case 8 months of the 25 year time frame. To get the schedule I setup a schedule that returns period dates based on the month and year. I think referenced that date using the following function: =INDEX('Project Schedule'!$1:$1,MATCH(G4,'Project Schedule'!$2:$2))+1 This references the months in Row 2, and returns the Period Value in Row 1. In this case returning the value of 14. but when I use a basic SumIf function to sum the total cost of the payments into the loan, it returns a "zero" value. Here is my sumif function SUMIF(A10:A410,"<=F4",G10:G410) Now if I just replace F4 with the value 14 it works and calculates correctly, but if I reference the cell F4 it returns a zero value. My only thought is that the Index function screws this up, and doesn't actually return a number value. Your thoughts?
Solved by K. H. in 22 mins
Using the INDEX and MATCH on excel functions; I am trying to display the top 3 clients who have raised the greatest number of queries per month. The challenge is where duplicate data is found. For example, in April Client 1, Client 4 and Client 5 all reported 2 issues each, so I would like my table to return all 3 client names, however, only Client 1 is being returned.
Solved by E. J. in 22 mins
need help understanding index match and what this formula is about
Solved by T. W. in 22 mins
Can you explain the use of INDEX MATCH. Thanks
Solved by G. W. in 16 mins
I have 2 files that I need help with Index& Match. The location on the sheets needs to be updated with the information on the table
Solved by D. Q. in 27 mins
I need to update the location on sheet with the information on the table using index & match.
Solved by Z. U. in 12 mins
I have tried a couple of times and lost so many credits LOL....I was hoping you could help me with the following using Index & Match. I need the update the location on my sheet with teh information on the second tab
Solved by B. Q. in 22 mins
Attached Input Test 2 is the last of several attempts with failed entries commented out. In VBA code attached to a Userform I am having trouble identifying the actual cell address in the price list using the value chosen from the combobox so that I can make that the activecell from which to offset two columns for the quantity entry. I have tried to use mixtures of Address, Index and Match Functions but just cannot make it work. Userform has one combobox and one input box. The combobox is populated by the prices entered in Col. A of the worksheet. The Inputbox will contain the quantities received against each price which is to be input in a column offset by 2 from the price. Input will be from between 20 and 60 documents each containing a mixture of items at different prices. Each document will be entered into individual columns so I will use a Count to increase the offset by 2 for each document with the Counter showing in a textbox on the Userform. Any assistance will be appreciated.
Solved by S. Q. in 16 mins
Hello, I need to use the attached index formula in excel. But it is no working propoerly
Solved by O. H. in 24 mins
I need to do a "fuzzy" index match or vlookup, but I am having trouble getting the wildcards to work. And I want to be able to do this without the fuzzy lookup add in, because I want to write a macro for this.
Solved by T. H. in 20 mins