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 The value to search for in the firs
MS Excel: How to use the TRANSPOSE Function (WS) This Excel tutorial explains how to use the Excel TRANSPOSE function with syntax and examples. Description The Microsoft Excel TRANSPOSE function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter. The TRANSPOSE 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 TRANSPOSE function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the TRANSPOSE function in Microsoft Excel is: TRANSPOSE( range ) Parameters or Arguments range The range of cells that you want to transpose. Note The range value in the TRANSPOSE function must be entered as an array. To enter an array, ent