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

 Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum Access Troubleshooter Access Developer Network Access AI Bot ------------ Excel Courses Excel Index ------------ Code Vault Testimonials Tip Jar Advice for Consultants

Excel VLOOKUP Function
By Richard Rost     16 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

 Age Subject From 16 years No Subject Richard Rost 16 years No Subject shisir

Start a NEW Conversation

Subscribe to Excel VLOOKUP Function