http://www.xlninja.com/2012/08/07/how-to-apply-vlookup-across-worksheets/Using different worksheets for a VLOOKUP function is a good way to create an efficient spreadsheet.