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.
Try this:
=XLOOKUP(H10,'2024_2025 Tax Table'!$A$3:$A$9,'2024_2025 Tax Table'!$C$3:$C$9,,1,1)