Loading...

Excel VLOOKUP From Another Workbook

187,711 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Aug 19, 2010

http://www.contextures.com/xlFunction... In a VLOOKUP formula, you can refer to a lookup table that is in a different Excel workbook. In this example, the price list is in one workbook, and the VLOOKUP formula is in the order data entry workbook. It is easier to create the reference if both Excel workbooks are open when you create the VLOOKUP formula. After you create the VLOOKUP formula, the price list workbook can be open or closed, and the formula will continue to work correctly.

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...