How do you use index formula in sheets?

I'm trying to figure out how to apply the index formula in Google Sheets. I want to understand how it works so I can use it to retrieve specific data from my spreadsheet.