Index Matching


Can someone please have a look at the attached workbook and advise me on the correct index match formula that I would need in order to match the specific school and account code to the financial year total?
I have attached an example of what I am trying to describe. Basically the cells in red I would like to have index match formulas instead of Vlookups. From there I would like to index match the school and account code to the financial year.

Any advice would be appreciated at this point in time

Who is Participating?
jimyXConnect With a Mentor Commented:
How about this approach?
Do the financial years have to be that exact format?

It would be better to create a "helper" column in column A if that were possible, would make a far quicker set of lookups.  

Also VLookup is probably more suitable than index matches - although can index match if you wish
For example you could do with Indirects and sumif's SchoolExample-1-.xlsx
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

vegas86Author Commented:
I would prefer index matching if possible but if not my main objective is to basically have the same formula through out the sheet so there isn't so much room for error when others use the workbook
MakriniConnect With a Mentor Commented:
The solution I provided means you don't have to modify the sheet name in the formula.  

As far as I know, indirect is the only way to do this..

Index match for A4


Index Match for D4
vegas86Author Commented:
Thanks guys, both answers were very helpful in their own ways!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.