INDEX(MATCH)) / LOOKUPS Processing Calculator Speed

I heard that using named ranges or table column names in a lookup (or in my case, I always use index match) instead of referencing an entire column or row makes Excel work faster.

I have a few spreadsheets that rely almost entirely on extremely large amounts of index-match formulas, and they all run extremely slow. Is it true that if I change my lookup ranges to tables and use the table column names or named ranges instead of using the entire column as a lookup, Excel will be able to run faster?

Example:
Sheet1 is my final presentation, so it uses index-match formulas
Sheet2 contains all my raw data. Column A is Product. Column B is Price.

In Sheet1, to show the relevant products and prices, I write in cell B2:
=INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0))
I do this in roughly 200 different cells in Sheet1 to show the necessary data.

Would Excel be able to run faster if I changed Sheet2's data to a table or named range and wrote someting like:
=INDEX(Sheet2_Cost,MATCH(A2,Sheet2_Product,0))

It looks through significantly less cells, so I guess it would be able to run faster, right?

thanks!