Excel will automatically add the other workbook’s name and the worksheet name in the formula. Create the VLOOKUP formula, and for the table_array argument, select the lookup range in the other workbook.Open both workbooks (this step isn’t mandatory, but makes it easier to create the link).To refer to another workbook in a VLOOKUP formula, follow these steps. If your price list is in a different workbook, you can still use a VLOOKUP formula to pull the data, by referring to the external list. However, you might want to keep your price list separate from the orders workbook, so the prices are easy to update. 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. If you’re 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.
0 Comments
Leave a Reply. |