Vlookup Problems #4: Lookup Table has got Bigger - Dynamic Lookup Table

★ Like this tip? Find more at http://bit.ly/Computergaga ★

If your Vlookup function has been set up using a standard cell references for the table array. When more rows are added to the lookup table the Vlookup will not pick these up.

When your table gets bigger, you could resize the table array in the Vlookup. However a better solution to this Vlookup problem would be to format your lookup table as a table, or to create a dynamic range name.

This video looks at how by formatting your range as a table it becomes dynamic. As more rows are added to your range, the dynamic table array picks them up. With your Vlookup function using this table, it therefore also uses the additional rows.

If for some reason the rows are not automatically detected, the table can easily be adjusted with a simple click and drag. Any formulas using this range will then be automatically updated.

The format as a table feature is available from Excel 2007 onwards. Another option is to create a dynamic range name by using the Offset function. This technique is not covered in this video, but a tutorial on his can be found on the link below.

Create a dynamic range name: http://youtu.be/VZaySAQs-Wg

Join the Audience:
★ Twitter: http://www.twitter.com/computergaga1
★ Facebook: https://www.instagram.com/computergaga1/
★ Blog: http://bit.ly/Computergaga

This is the fourth video in the common Vlookup problems series. In this series we explore the most common reasons why your Vlookup functions are not working.

Be sure to check out all the videos in the series for a complete understanding of the anatomy of Vlookup and the potential problems you can encounter.

Видео Vlookup Problems #4: Lookup Table has got Bigger - Dynamic Lookup Table канала Computergaga
Microsoft Excel (Software), vlookup problems, common vlookup problems, vlookup function, vlookup formula, dynamic table array, dynamic lookup table, computergaga