Create Dashboards with Dynamic VLOOKUP Function ( with Match/Indirect/Named Ranges) - Excel

Опубликовано: 25 Октябрь 2016
на канале: ExactProBi

5,876

My Amazing Excel, Powe Query, dashboards, Power BI Books Collection: https://www.amazon.com/shop/prohdgami...

Subscribe to my Channel here http://bit.ly/SubToExAC
Like My Facebook Page here   / exaccounting
====================================================================================
Link to the workbook https://1drv.ms/x/s!AiuaufKir82Mxg84l...

VLOOKUP is fantastic and a big time saver excel function for looking up values... especially in Accounting/Finance areas.

Today I will show you how to create dynamic VLOOKUP function along with Match, Indirect and Named ranges...

Combining these four, we can have very dynamic and powerful data extraction formula which can be applied to various kinds of Dashboard and reports.

I highly suggested you go through the basics of these four excel tools by following below videos (if you are not familiar with these functions already)

VLOOKUP    • How to Use the VLOOKUP Function in Excel
MATCH    • Excel Lookup Series #8: MATCH Function
INDIRECT    • Excel Name Trick #7: INDIRECT functio...
NAMED RANGES    • How to Create Named Ranges to Use in ...

As always thank you for watching, please leave LIKE button if the video had helped you, share with your friends and on social media

Subscribe for more advanced excel tips...