Vlookup Problems #3: Column Inserted into Table Reference

★ Liked the Video? Subscribe: http://bit.ly/ComputergagaYouTube ★ If a column is inserted into the lookup table used by a Vlookup function, it can return the incorrect information. We can solve this Vlookup problem by creating a dynamic column index number, or by protecting the worksheet to prevent users from inserting columns into the lookup table. We first look at protecting the worksheet and disabling the potential for someone to insert, or delete, a column from the lookup table range. This solution may not be sufficient if you need users to be able to insert columns. However it is the easiest and most lightweight solution for your spreadsheet. Protecting a worksheet is a massively useful tool in Excel. This video just gives a quick glimpse into its potential so you can see how it could help you. We then look at nesting the Match function into the column index number argument. The purpose of this function is to return the position of an item in a range. Therefore we can ask it to return the column number of a heading within a range of cells. By using the Match function you create a dynamic column index number. It is very durable and versatile. If a user inserts, or deletes a column, it will not affect the Vlookup function. It continues to return the correct column number. Join the Audience: ★ Twitter: http://www.twitter.com/computergaga1 ★ Facebook: https://www.instagram.com/computergaga1/ ★ Blog: http://bit.ly/Computergaga This is the third video in the common Vlookup problems series. In this series we explore the most common reasons why your Vlookup functions are not working as they should. 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.