Forum Discussion
Solved
Match Index Function
Good day I'm facing a dilemma with my Excel spreadsheet, and I hope you can help. I've attached a sample spreadsheet for reference. The key sheets are: 2024_2025 Tax Table: This sheet conta...
See the attached demo workbook. It uses formulas only.
Change
=INDEX('2024_2025 Tax Table'!$C$3:$C$9, MATCH(H10, '2024_2025 Tax Table'!$B$3:$B$9, 1))
to
=INDEX('2024_2025 Tax Table'!$C$3:$C$9, MATCH(H10, '2024_2025 Tax Table'!$A$3:$A$9, 1))
Thank you HansVogelaar. That worked. Thank you