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

Hello, I am attempting to use an Index lookup to list specific returned results based on a single order number, I also want to exclude results with non alphanumeric values. I have my Index function working correctly, and I have a separate lookup verifying if the source values are numeric or alphanumeric. Can you help me combine them.
Solved by O. J. in 14 mins
Need help with some formulas using array or index formulas not sure.
Solved by M. J. in 14 mins
Need help with some formulas using array or index formulas not sure. Specifically need to pull information from Accounts Overview tab into Accounts By Rating tab based on the rating assigned.
Solved by X. C. in 13 mins
I need to index match to return a list, then i need to use that list as criteria in a sumifs
Solved by T. S. in 24 mins
I work in a bank looking for an excel solution to a problem. On day 1 I have two identical tables filed with identical data - so A2 (and B2 and C2 etc) in table 1 = A2 (and B2 and C2 etc) in table 2. Each table has 60 columns and ~100 rows. Each of the rows represents a different company, best identified by a Client ID (a unique number that never changes) that appears in one of the middle columns. All other company information within a row can change however. Table 1 will be the most recent data (refreshed every day) and table 2 will be the hard coat version, copy and pasted from Table 1 using the previous day's data. I have a third table that compares the specific cells within each of the rows within each of the tables and uses an IF function along the lines of: If A2 in table 1 = A2 in table 2, then "OK" otherwise "Not Okay"; if A3 in table 1 = A3 in table 2, then "OK" otherwise "Not Okay" etc. On day 1, when the tables and data are identical, the same rows and cells of the same company are being compared. The problem is the live data in table 1 will include new rows of new companies that can insert themselves anywhere, which means that the company found in row A in table 1 may no longer be the same company found in row A in table 2. And I can’t just sort both tables’ data by Client ID as a simple solution as table 2 will have rows / companies that no longer appear in the live data in table 1. I've tried to work out which function I should use to match the rows of the two tables using the Client ID - maybe Index Match - but can't get it to work. In basic English the solution should be: In table 1, use the client ID in row A (or B or C or D etc) and return the row in which the same client ID appears in table 2. Once the correct rows have been matched, then compare A2 to A2, A3 to A3 etc using the IF function mentioned above. I could potentially move the Client ID all the way to the left in order to use a VLOOKUP but not sure this function will work. Please help.
Solved by M. H. in 30 mins
I am hoping to find a formula to fix this issue. I have a matrix file where the information is unique in rows and extended out to weeks across columns (Special Projects & New Products). This is meant to be a capacity/planning tool. People will be spreading the numbers in the weeks, 29-52 instead of one lump sum. The final sheet1 is to put all information in a vertical (rows) format. I am using an index formula to find the week number (29-52). The rest of the information needs to refer back to the individual row for 24 weeks. I have been copying a pasting these into lump sum groups which is clumsy and torturous. I tried an offset formula but was unsuccessful. Any ideas so I can just drag the formula down and it keeps the group together?
Solved by I. H. in 21 mins
Im trying to a index and match to return multiple columns and rows of data. I cant figure out how to do it.
Solved by O. F. in 25 mins
For the midterm project you will design and create a workbook. The workbook should help solve some problem or serve a purpose that is of personal value to you, a friend or an associate. Create a short description of the workbook you plan to create as descrbied in Part I of the project. Keep in mind that your workbook must implement the technical requirements described in part II. CS302 Midterm Project Part I: Write a description of the Excell workbook you plan to create. Be sure to choose a project concept that will be of personal use to you, a friend or work associate. Preview your description with your instructor for approvail before proceeding to part II In your description include the following: 1. Who will use the workbook 2. Describe what the workbook will do (What purpose will it serve?) 3. Describe the type of data that will be stored in the workbook 4. Describe some of the analysis and reporting features of the workbook. Midterm Project Part II: Create the workbook to complete your project. Your workbook must implement the following technical requirements. 1. Well formatted with some background color, borders and style 2. Contain at least one database sheet with at least 15 records and 4 fields of data and at least one calculated field. 3. Apply appropriate named cell references to your workbook. 4. Implement goal seek analysis using absolute cell references and an assumption area. 5. Use conditional formatting on the database sheet. 6. Use two or more of the functions from this list: if(), iferror(), sumif(), countif() 7. Use a database lookup function like VLOOKUP() using a lookup table. 8. Create a filter sheet that will demonstrate the use of numberic and text filters applied to your datasheet. 9. Create some scenarios and generate a summary report. 10. Add at least one macro with a button to run the macro. 11. Use solver in some way. Be sure to create an answer report. 12. Add appropriate and consistant data validation fields 13. Create 2 charts of different styles using different data. Include examples of data labels, modify axis settings, legends and titles. 14. Add an imbedded image with a link to a web web site. 15. Add cell and worksheet protection. Highlight the unprotected cells. Make the password "MIDTERM". 16. Be sure to add comments to your project workbook pointing to each of the requirements above. Include the requirement number as the first line in the comment. The comment should point to where you implemented each of the technical requirements. To add comments right click the cell and select the insert comments menu option. 17. Add a sheet to your finished workbook named INDEX. The INDEX will list each of the technical requirements above. The INDEX sheet should be the first sheet in your sheet tab. In the A column of the INDEX sheet create a list titled 1 thru 16 matching up with the 16 technical requirements. Add a hyperlink so that when the instructor clicks on the link it will goto the worksheet and cell containing an example of the technical requirement. In the B column add a short description of your implementation of the technical requirement. This is required for grading purposes. If these hyperlinks are not added to your workbook it will affect your project grade. Submit your description document and project workbook for grading.
Solved by C. J. in 23 mins
I'm trying to get a value from a cell that's at the intersection of a row & a column. The rows are a series of ranges, and the columns are single values. I've tried vlookup and hlookup, but can't get them to work. I'm not good enough to use index or match. I hope I've explained that ok. Thanks in advance
Solved by O. Y. in 30 mins
I've created a picture lookup using index, match and name manager - just wondering if I can copy this down easily to the other cells or if I need to create a new formula each time?
Solved by D. Y. in 27 mins