For this, we define the following arguments: VLOOKUP(lookup_value, Sheet!range, col_index_num, )Īs an example, let's pull the sales figures from Jan report to Summary sheet. The generic formula to VLOOKUP from another sheet is as follows: The difference is that you include the sheet name in the table_array argument to tell your formula in which worksheet the lookup range is located. It's very similar to a regular VLOOKUP formula that searches on the same worksheet. Dynamic VLOOKUP to pull data from multiple sheets into different cellsįor starters, let's investigate a simplest case - using VLOOKUP to copy data from another worksheet.VLOOKUP across multiple sheets with IFERROR.But with just a little patience, we will figure them out :) The good news is that Microsoft Excel provides more than one way to do this, and the bad news is that all the ways are a bit more complicated than a standard VLOOKUP formula. More often, you will have to search across multiple sheets or even different workbooks. When looking up some information in Excel, it's a rare case when all the data is on the same sheet.
#How to use vlookup in excel 2010 with example how to#
Excel.The tutorial shows how to use the VLOOKUP function to copy data from another worksheet or workbook, Vlookup in multiple sheets, and look up dynamically to return values from different sheets into different cells.
Jelen is author of the five-star reviewed Guerilla Data Analysis Using Microsoft Excel, co-author of VBA and Macros for Microsoft Excel, co-author of Pivot Table Data Crunching, and author of Learn Excel From Mr. His website hosts more than 12 million page views annually.
As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. He is an accomplished Excel author and the principal behind the leading Excel website,. Expert Bill Jelen simplifies powerful features including PivotTables, PowerPivot, Sparklines, Goal Seek, Cell Styles, Color Scales, Icon Sets, Data Bars, Web Queries, Backstage View, and more! Get more done faster with customized workbooks, the Quick Access Toolbar, and keyboard shortcuts…control and analyze data more effectively…communicate more visually with new charting tools and SmartArt…and plenty more! Just watch: You’ll master high-powered Microsoft Excel 2010 skills at your own pace–and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2010 fast–from novices to experienced power users.īill Jelen is MrExcel, as well as an Excel MVP. You’ve got Microsoft Excel 2010…now get the most out of it, faster and more easily than ever before! In 90 quick video lessons, Power Excel 2010 with MrExcel shows how to maximize your productivity with Microsoft Excel 2010’s best tools and shortcuts. How to Use VLOOKUP in Microsoft Excel 2010 from “Power Excel 2010 with Mr.