![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |