Multi-Tab Index & Match/Lists Help Please.

Hello all,

I just stared taking excel classes and am still learning. I recently created a process that will help my company and my clients a great deal but my thought is way ahead of my Excel Knowledge which is very little and I am hoping someone can help me with this spreadsheet.

In this excel you will find 3 sheets and they are as follows.

1: A general worksheet to input all of my data.
2: A blank worksheet that I hope to only show rows from Sheet 1 based off of which "Banking center" is selected from a drop down at the top of the sheet. (I don't know how to create that)
3. All of the data I want to pull from to autofill and Index/match on in different cells on sheet 1.

I added notes above the cells on sheet 1 to try and explain what I want to do. If anyone has any tips that would be really helpful.

Thanks again!

Hi all, Is there anything else I can do to get any tips here? If not, can anyone suggest a service I can contact to help me create these formulas for this spreadsheet?

When submitting a sample Excel workbook, it helps us if you give some examples of what you are trying to achieve, but there is only partial data for one record shown in your example file. Compile the examples manually, so that we can see where you are trying to get to.

To create a drop-down, you would normally use Data Validation for this (available on the Data tab). You seem on Sheet2 to have already defined the choices available for a number of fields, so if you give each of these ranges a name (using Name Manager, on the Formulas tab), then you will be able to refer to the name in the DV dialogue box (under List).

Hope this helps.

Pete

Thank you very much, Glenn. This is perfect. Sorry about the babble. I was trying to figure out how to do "if" formulas on sheet 1 to auto populate cells based on the criteria of others. I will work on that some more offline.

Thanks again