To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

How Do I Reference a Cell in Another Worksheet in Excel?. Learning to use Excel worksheets like relational databases can help you save time, eliminating duplication when managing large projects.

Open an Excel worksheet and add data to two columns, where the first column has one number and the second has four different ones. For example, type "18" in cell "A1" and "30", "13", "80" and "7 ...

You can reference a list on another sheet, but it takes a bit more work. In this tutorial, I’ll show you how to populate a dropdown with data on another sheet.

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.