Posts Tagged ‘Lookup’
Using HLOOKUP function to generate grades from marks (can be adapted)VLOOKUP Between Separate Workbooks and Worksheets in Excel
Friday, June 5th, 2009
http://www.TeachExcel.com
This will teach and show you how to use the vlookup function between separate worksheets and workbooks in excel.
You will learn how to use the vlookup to search through lists in closed workbooks and in separate excel files.
To follow along with the excel spreadsheet seen here and to find more excel stuff including free macros, keyboard shortcuts, and a forum, go to:
http://www.TeachExcel.com
Duration : 0:6:23
E1.7 VLOOKUP across two worksheets
Monday, May 18th, 2009
Using VLOOKUP in one worksheet to look up values located in a second worksheet
Duration : 0:2:8