Vlookup in excel tutorial for beginners. This video explains how to use the vlookup function in excel to compare two table and pull matching data how to vlookup in multiple sheets with multiple cr. 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. Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. The vlookup vertical lookup function in excel looks up a piece of information or value from one column of a table or dataset and extracts and returns some corresponding value or information from another column.
Most often you will have to pull matching data from a different worksheet.