Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.