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 »

Excel Column Function

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

Excel Choose Function

This post will guide you how to use Excel CHOOSE function with syntax and examples in Microsoft excel. Description The Excel CHOOSE function returns a value from a list of values. The CHOOSE function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The CHOOSE function is available in… read more »

Excel Areas Function

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

Excel Address Function

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

Sidebar