• Home
• Video Tutorials
  • Arrays
  • Charts & Graphs
  • Financial Functions &
  • Models
  • Formatting
  • Formulas
  • Data Analysis Tools
  • Import / Export / Link
  • Lists & Forms
  • Macros
  • Printing
  • Security
  • Tips & Tricks
• Free Macros
• Excel 2007 Resources
• Keyboard Shortcuts
• Forum
• Contact/About

VLOOKUP() Between Separate Worksheets and Workbooks

This is a video tutorial that will show you how to use the VLOOKUP() Function between separate worksheets and separate workbooks in excel. This shows you how to search a list on another workbook or worksheet, even if they are closed. This tutorial also ties in with linking workbooks and worksheets within formulas in excel.

Topics Covered      VLOOKUP()      Use VLOOKUP() Between Separate        Worksheets and Workbooks      Search lists on Separate        Worksheets and Workbooks, even        if they are closed    Difficulty:         Intermediate    Video:               Yes    Spreadsheet:     Yes     1   2