Excel Tutorial Vlookup Video

Learn to use the vlookup in this free excel video tutorial.

Excel tutorial vlookup video. This video is a brief guide on how to use the sometimes complex vlookup function in microsoft excel. Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. I use excel 2007 in this video but it works in 200. Vlookup is a very popular function and excel that allows you to look up information in a table that could be on the same sheet on another sheet or even in another workbook.

So as an example ill enter part numbers the thing i know and find out prices the thing i dont know. In other words it allows you to find look up a value from one column of data and returns its respective or corresponding value from another column. In this vlookup guide we will learn. Want more excel videos.