Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Dynamically Updated Vlookup Table in Microsoft Excel

This Microsoft Excel tutorial shows you how to make a dynamically updating vlookup formula. After viewing this tutorial, you will be able to write a vlookup formula that will always include the most up to date data in the table you are searching.

This trick allows you to dynamically increase the size of the vlookup table, within the vlookup formula itself, automatically. This means that if another record or more data is added to the table, the vlookup formula automatically readjusts to include the new information. This is a great tutorial and it does assume that you already know how to make a vlookup formula on its own.
   Topics Covered
Make Dynamic Vlookup Formulas
Vlookup Formulas Where the Vlookup Table automatically updates its size references when new entries are added.
OFFSET() & COUNTA() Functions
Dynamic Vlookup Table Size
   Difficulty:         Intermediate
   Video:               Yes

Got a Question? Ask it Here in the Forum.