Hide Vlookup Souce Data in Excel

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
749 views
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Published on Nov 15, 2011 by

Go to http://www.teachexcel.com for more.

Learn how to hide Vlookup source data in Excel. This allows you to prevent the user from seeing the data used by the vlookup and to create a cleaner and more professional looking spreadsheet.

You will learn three different ways to hide the source data or table array data used for vlookup functions. This especially useful when you have the table array data on the same worksheet as the vlookup function but don't want to see all of this data. Also, these methods can be used to hide any in-cell data in Excel, even if it doesn't have anything to do with functions or formulas, such as the vlookup function.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • HI I wounder if any one can help me please, i need to hide a row which is row 17 but some how link it so when say you type A5 the table disappears. thanks

  • I liked the font color change, sneaky! move the data like 50 col over too :)

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more