I am trying to make a list scrollable in excel. I want to use the Index Function. Any tips or any suggested resource which I can refer to. Below is my formula that I am using in my sheet to get the data from another worksheet.
INDEX(Table1[Comm Amt], MATCH($A7, Table1[helper],0))
PS: I don't want to use macro