Scroll Bar using Index Function I don't want to use Offset Function
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.
No comments:
Post a Comment