Excel Student Fee Lookup
Budget: $10 – $30 USD
I have one workbook that contains twelve monthly sheets (Apr-26 through Mar-27). Each sheet lists every student’s Registration No., the fee due for that month, and any payments received.
What I need is a simple way to type or choose a student’s Reg No. once—ideally through a validated drop-down on a summary sheet—and have Excel instantly pull:
• the current month’s fee figures from the relevant month sheet, and
• all previous months’ payment history for that same Reg No., displayed in chronological order.
Because I routinely update these sheets, the formulas must work even after new rows are added. I would like this built with INDEX/MATCH (my preferred function set) rather than VLOOKUP, and I’m open to an elegant VBA touch only if absolutely necessary.
Please return:
1. The enhanced workbook with the summary (lookup) sheet fully functional.
2. Clear notes inside the file so I can maintain or extend the formulas later.
I’m ready to review and approve as soon as the solution is proven on my end, so a quick turnaround is appreciated.
What I need is a simple way to type or choose a student’s Reg No. once—ideally through a validated drop-down on a summary sheet—and have Excel instantly pull:
• the current month’s fee figures from the relevant month sheet, and
• all previous months’ payment history for that same Reg No., displayed in chronological order.
Because I routinely update these sheets, the formulas must work even after new rows are added. I would like this built with INDEX/MATCH (my preferred function set) rather than VLOOKUP, and I’m open to an elegant VBA touch only if absolutely necessary.
Please return:
1. The enhanced workbook with the summary (lookup) sheet fully functional.
2. Clear notes inside the file so I can maintain or extend the formulas later.
I’m ready to review and approve as soon as the solution is proven on my end, so a quick turnaround is appreciated.