MS Excel: How to use the VLOOKUP Function (WS) This Excel tutorial explains how to use the VLOOKUP function with syntax and examples. Description The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet. The VLOOKUP function is actually quite easy to use once you understand how it works! If you want to follow along with this tutorial, download the example spreadsheet. Download Example Syntax The syntax for the VLOOKUP function in Microsoft Excel is: VLOOKUP( value, table, index_number, [approximate_match] ) Parameters or Arguments value T...
Hi My All Friends, I am Govind Ram Bishnoi I am Trainer In NIIT For Advenced Excel