Has anyone had issues with normal INDEX/MATCH stuff in Google Sheets?

I was actually OK with moving from Excel to Google Sheets since the coverage of functions seemed mostly ok, minus all the new cool shit they added in one of the more recent releases (XLOOKUP, etc) but I literally tried a trivial INDEX/MATCH with a simple 5x20 matrix of price values and literally could not get it to work even though the identical "code" worked in Excel.

Really, really frustrating. I was working at a hedge fund at the time and I was simultaneously working on a real time portfolio dashboard as a web app, and needed to also have a stopgap solution in the form of a spreadsheet for people to play with and debugging differences in Google's spreadsheet function implementations and Excel's was infuriating