In this video, you will learn how to use formulas (IndexMatch & Xlookup) and a scroll bar to create a scrollable table and chart.
Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!
Content
00:03 Intro
00:40 Scroll bar
02:07 IndexMatch
04:38 XLookup
06:23 Chart
Thank you!
Connect with me on:
👉Instagram / youexceltutorials
👉Facebook / youexceltutorials
👉Twitter / youexceltutor
👉 TikTok / youexceltutor
👉LinkedIn / bunmi-sanusi
🎬Check these videos:
Combo Chart • Excel Combo Chart || Highlight Maximu...
Waterfall Chart • What is EBITDA? || EBITDA Bridge || W...
Pivot Chart • PIVOT CHARTS [for all chart types]
🔽Link to file https://docs.google.com/spreadsheets/...
📢” But you must do this: Tell the truth to your neighbors. When you make decisions in your cities, be fair and do what is right. Do what brings peace” Psalm 12:9 (NLT)
#xlookup, #indexmatch, #Scrollbar
Watch video Scrollable Excel Table and Chart || IndexMatch/ XLookup || Scroll Bar (Form Control) online without registration, duration hours minute second in high quality. This video was added by user YouExcel Tutorials 12 April 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 879 once and liked it 34 people.