Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Excel VLOOKUP Function
By Richard Rost     14 years ago

I get asked this at least once a week: "how do I look up a value from another sheet in Excel?"

To do this, you can use the VLOOKUP function. Let's say you have a list of employees and their hourly pay rate in Sheet1, and you want to make a list of each employee and how many hours they worked in Sheet2. You can use the VLOOKUP function to get their pay rate from Sheet1 so you can calculate their total pay.

Here's a free tutorial (with video) that will explain VLOOKUP in more detail:

VLOOKUP TUTORIAL

Yes, we cover this in depth in one of our classes, Microsoft Excel 202.

RR