How To: Use VLOOKUP across worksheets in MS Excel 2007

Use VLOOKUP across worksheets in MS Excel 2007

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. In this MS Excel video tutorial, you'll learn about using VLOOKUP in one worksheet to look up values located in a second worksheet. For more on using VLOOKUP across Excel worksheets, watch this MS Office how-to.

Have an iPhone? Check out all 200+ new features coming in iOS 13.

Get the Gadget Hacks Daily

Life hacks for your smartphone.

1 Comment

Hi, thanks for explanation! For simpler illustration of how Vlookup works I'd also recommend the following video tutorial:

http://www.myhowtoos.com/en/excel-howtoos/84-how-to-match-values-in-excel-using-vlookup

Share Your Thoughts

  • Hot
  • Latest