Video tutorial vlookup excel 2007. I use excel 2007 in this video but it works in 200. When using the vlookup function in excel you can have multiple lookup tables. Download the excel file. In this ms excel video tutorial youll learn about using vlookup in one worksheet to look up values located in a second worksheet.
Microsoft office excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets as well as analyze and share information to make more informed decisions. Over 70 videos to help you master excel. In this ms excel video tutorial youll learn about using vlookup to look up values located in a table. Get the free 7 hour learn excel 2010 course.
Create two named ranges. You can use the if function to check whether a condition is met and return one lookup table if true and another lookup table if false. This video is a brief guide on how to use the sometimes complex vlookup function in microsoft excel.