Excel Lookup/Reference Functions

Excel Vlookup Function

This post will guide you how to use Excel VLOOKUP function with syntax and examples in Microsoft excel. Description The Excel VLOOKUP function lookup a value in the first column of the table and return the value in the same row based on index_num position. The VLOOKUP function is a build-in function in Microsoft Excel and… read more »

Excel Rows Function

This post will guide you how to use Excel ROWS function with syntax and examples in Microsoft excel. Description The Excel ROWS function returns the number of rows in a cell reference. The ROWS function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The ROWS function is available… read more »

Excel Row Function

This post will guide you how to use Excel ROW function with syntax and examples in Microsoft excel. Description The Excel ROW function returns the row number of a cell reference. The ROW function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The ROW function is… read more »

Excel Match Function

This post will guide you how to use Excel MATCH function with syntax and examples in Microsoft excel. Description The Excel MATCH function search a value in an array and returns the position of that item. The MATCH function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function…. read more »

Excel Lookup Function

This post will guide you how to use Excel LOOKUP function with syntax and examples in Microsoft excel. Description The Excel LOOKUP function will search a value in a vector or array. The LOOKUP function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The LOOKUP function is available… read more »

Excel Indirect Function

This post will guide you how to use Excel INDIRECT function with syntax and examples in Microsoft excel. Description The Excel INDIRECT function returns the cell reference based on a text string, such as: type the text string “A2” in B1 cell, it just a text string, so you can use INDIRECT function to convert… read more »

Excel Index Function

This post will guide you how to use Excel INDEX function with syntax and examples in Microsoft excel. Description The Excel INDEX function returns a value from a table based on the index (row number and column number). You can use INDEX function to extract entire rows or entire columns. This function is used to… read more »

Excel Hyperlink Function

This post will guide you how to use Excel HYPERLINK function with syntax and examples in Microsoft excel. Description The Excel HYPERLINK function creates a shortcut/hyperlink to a document, when you click this hyperlink, the excel will open the file that is stored on a network server or local location. ​The HYPERLINK function is a build-in function in Microsoft Excel and… read more »

Excel Hlookup Function

This post will guide you how to use Excel HLOOKUP function with syntax and examples in Microsoft excel. Description The Excel HLOOKUP function lookup a value in the top row of the table and return the value in the same column based on index_num position. The HLOOKUP function is a build-in function in Microsoft Excel and… read more »

Excel Columns Function

This post will guide you how to use Excel COLUMNS function with syntax and examples in Microsoft excel. Description The Excel COLUMNS function returns the number of columns in an Array or a reference. The COLUMNS function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The COLUMNS function… read more »

Sidebar