Get instant live expert help with INDEX Function in Excel

I am trying to solve a relative simple probelm in VBA. Need to set up an iterative process that distributes the residual on an index over its constituents . And also help with vba index match. Can you help?

i am trying to construct an index capping its weight at 20%. this means that the sum of the constituents is less than 100%. i need to take the residual = 100% - sum of the weight and distribute it proportionally to the uncapped weights. it is an iterative process that needs to be conducted until the residual is = 0.0001%. It requires nested loops and array as inputs. i could have done this in the past but have not programmed in 15 years.

Read a column on one sheet and if a match on another sheet then print content in cell to the right of first sheet in the cell to the right of the matching sheet. MATCH and INDEX across sheets

I AM IN NEED OF A FORMULA (MUST BE A FORMULA BECAUSE INFO CHANGES) THAT FINDS THE FIRST UNIQUE VALUE IN A COLUMN THEN RETURNS THE VALUE OF GIVEN CELL IN SAME ROW IN ANOTHER COLUMN. LIKE WHAT THIS FORMULA DOES FOR MATCHING CELLS: =IF(INDEX(Z:Z,MATCH(B3,Y:Y,0)),0) AND THEN I WOULD NEED TO KNOW HOW TO ADJUST FORMULA SO I CAN FIND THE SECOND UNIQUE FORMULA AND ITS CORRESPONDING CELLS... AND SO ON. THANKS

I am looking for help correcting an existing formula using index, indirect and match

Hi, I have an excel formula that I have put together but the issue I am having is that the formula runs too slow. The purpose of this document is for the user to create an ongoing list of company names which will have duplicates. The on a separate sheet, it needs to extract only the unique company names from the original list. This would be a working list so this needs to update as company names are being inputted within the 1st sheet. I have a formula that works correctly, but the problem that is that it slows down the document to the point the document can't be used. The document is calculating the formula each time which is causing the slowness. Does anyone have a solution for this? Here is the formula I am using: =IFERROR(INDEX(TableName,MATCH(0,INDEX(COUNTIF($A$1:A1,TableName),),0)),"") I hope this makes sense. Any help would be appreciated.

I need help with nested if and index excel match multiple criteria from different arrays

I want to copy over data from one worksheet to another, but it must meet certain criteria. See below for FAQs, formula being used currently, and the problem it's causing: ___________________________________________________ Worksheets Involved: Column A of worksheet 'Key Issue Details' contains a list of exam titles Column C of worksheet 'Key Issue Details' contains a list of corresponding exam types (Audit, Credit Review, etc.) Cells A20:A22 of worksheet 'PickList' contain all of the possible exam types found in column C of 'Key Issue Details' Column C of worksheet 'Calendar & Exam Summary' (cells A5:A16), contains an empty list for all Audit type exams ___________________________________________________ I want to enter a formula into cells A5:A16 on worksheet 'Calendar & Exam Summary' that will copy over all exam titles from 'Key Issue Details' column A, but only if 'Key Issue Details' column C matches any of the cells A20:A22 in 'PickList'. I am using the formula below which does retrieve this information, however instead of copying them over one after the other in Column C ('Calendar & Exam Summary'), it is matching row for row. For example: Formula being used: =IFERROR(INDEX('Key Issue Details'!$A$2:$B$2,MATCH(PickList!$A$20,'Key Issue Details'!$C$2:$D$2,0)),"") 'Calendar & Exam Summary' ...........'Key Issue Details' C5 - ...................................C2 - Exam A (doesn't match PickList) C6 - Exam 1.......................C3 - Exam 1 (Meets Criteria) C7 - ...................................C4 - Exam B (doesn't match PickList) C8 - Exam 2.......................C5 - Exam 2 (Meets Criteria) C9 - Exam 3........................C6 - Exam 3 (Meets Criteria) I would like it to look like this: Calendar & Exam Summary ........ Key Issue Details C5 - Exam 1........................C2 - Exam A (doesn't match PickList) C6 - Exam 2........................C3 - Exam 1 (Meets Criteria) C7 - Exam 3........................C4 - Exam B (doesn't match PickList) C8 - .....................................C5 - Exam 2 (Meets Criteria) C9 - .....................................C6 - Exam 3 (Meets Criteria)

Hi, I'm trying to sumif an index match and although it's working for the first year, the formula is throwing up incorrect values for the rest of the term- I can't figure it out! (Got a 10 year cashflow in quarters, trying to sum the rent in each year)

I want to create a formula using the MATCH function nested within the INDEX function to retrieve the Class that was selected (by the x) in E4:F10. The MATCH function should find the row where the x is located and should be used within the INDEX function to retrieve the associated Class value from the same row within F4:F10