Look Who it Was Random video

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

2,348 views · Published 23 March 2014 · 5:27 · Indexed 26 September 2026

Channel: Computergaga · 2014 · Howto & Style

Watch on YouTube

★ 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.

More from this channel