This formula means that it should scan column A (from the 2 nd row to the 10 th row) to find the cell that has the same value as B13. =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).Īn example of this formula is as follows: =VLOOKUP(B13,A2:C10,2,FALSE). With this feature, they can easily look up a price of an automotive part by the part number, or find an employee name based on their employee ID. For financial staff, this VLOOKUP may be one of the features that they will use frequently.
According to Microsoft, if you need to find things in a table or a range by row, use VLOOKUP. VLOOKUP function is an important feature in Excel. Easy deploying in your enterprise or organization. Combine Workbooks and WorkSheets Merge Tables based on key columns Split Data into Multiple Sheets Batch Convert xls, xlsx and PDF.ģ00 powerful features.Super Filter (save and apply filter schemes to other sheets) Advanced Sort by month/week/day, frequency and more Special Filter by bold, italic.Extract Text, Add Text, Remove by Position, Remove Space Create and Print Paging Subtotals Convert Between Cells Content and Comments.Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.
If the lookup table workbook is open, the VLOOKUP formula will show the workbook name and the referenced range address, but, if the lookup table workbook is closed, the full file path for the lookup table workbook will be shown in the formula as following screenshot shown:ĭemo: Vlookup to another worksheet with Kutools for Excel After finishing the arguments, please click OK, then drag the fill handle over to the cells that you want to contain this formula, and you can see the corresponding values from another workbook will be returned: In the Function Arguments dialog, choose the lookup-value in the current workbook, and then select the lookup range or table-array from another workbook, then enter the col-index-num that your matched value is returned, at last, type FALSE into the Range-lookup text box, see screenshot:Ĥ. Then create the VLOOKUP formula, click one cell where you want to put the result, and then click Formulas > Lookup & Reference > VLOOKUP, see screenshot:ģ.
Open both workbooks that you want to vlookup from one to another.Ģ. To vlookup from one workbook to another workbook, you can use the VLOOKUP function as usual, and you just need to change the lookup range to another workbook, see following formulas: =VLOOKUP(A2,'Sheet31'!$A$2:$C$7,2,FALSE)ġ. Supposing I have the following two workbooks which are Jan-orders and Feb-orders, now, I want to vlookup from the Jan-orders and return their corresponding values into Feb-orders. As we all known, the VLOOKUP function can be used in the same workbook, have you ever tried to apply this VLOOKUP function in two different workbook? In fact, this function also can be applied between two workbooks, please read this article to know more details.