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