Thank you. This is great, but there is an anomaly....
1. If you delete the contents of any data from the Worksheet from where the data is pulled from e.g. Cell 'Attendance'B6 "Total", the formula, not only returns a blank or #N/A, as expected but it also populates the next cell down it...
Here you go Tanvir. Using the data in Worksheet 'Attendance' I wish to populate the other tables, using Index/Match formulae. The Table is dynamic, monthly a new set of data is added.
Below is a screenshot of my attempt of using Index Match formula for multiple criteria in Column F. Column E is my expected output.
I have 3 Questions for support on...
1) How do I fix the Index Match formulae for Cells F6 & F7. It does not return a value because the lookup Cells A6 & A7...