Vlookup on Hidden Worksheets in Excel HD

Go to http://www.teachexcel.com for more. Learn how to use Vlookup search functions on separate hidden worksheets in Excel. This allows you to hide all source or raw data so that the end-user will not be able to see or easily change the data used in the vlookup search. This will allow you to make less confusing spreadsheets that are more difficult for the end-user to mess-up. This tutorial shows you how to create the vlookup and then hide and unhide the worksheet with data in a step-by-step manner.