How To Use Vlookup In Excel 2010 From A Different Workbook

The value you want to look up must be in the first column of the range of cells you specify in the tablearray argument.

How to use vlookup in excel 2010 from a different workbook. Vlookup is a function which can be used to reference columns from the same sheet or we can use it to refer it from another worksheet or from another workbook the reference sheet is same as the reference cell but the table array and index number are chosen from a different workbook or different worksheet. For example in the screen shot below the order form is on the orders worksheet and a vlookup formula in column d pulls the cost from a pricing table on the prices worksheet. Sheet1 range is the actual range for table array ie. Vlookup is an excel function.

Workbook is the name of the external workbook ie. Excel vlookup from another workbook if youre filling in an order form in excel you can use the vlookup function to find the selling price for each item in the sales order. In its most common usage vlookup is a database function meaning that it works with database tables or more simply lists of things in an excel worksheet. In this example the price list is in one workbook and the vlookup formula is in the order data entry.

In fact this function also can be applied between two workbooks please read this article to know more details. Lookupvalue can be a value or a reference to a cell. How to vlookup to another workbook. Then when entering the tablearray argument browse to the the external workbook and select the.

This article will assume that the reader already has a passing understanding of excel functions and can use basic functions such as sum average and today. In a vlookup formula you can refer to a lookup table that is in a different excel workbook. The value you want to look up. The easiest way to enter a reference to an external table is to begin entering the vlookup function normally.