All resources related to Lookup and reference for Excel and Google Sheets.

All articles
Lookup and reference

Excel HYPERLINK Function

What is the Excel HYPERLINK function? The Microsoft Excel HYPERLINK function is used to help return a Hyperlink from a specific destination as well as a “friendly name”. You can make use of the Excel HYPERLINK function to establish a clickable Hyperlink with the given formula. Also, the Excel HYPERLINK...

Excel ROWS Function

We can use the Excel ROWS function to count the number of rows in a specified array or reference. In easy steps, we will walk through the process of checking an array reference and count the number of rows in that reference. Figure 1: Results of using the Excel ROWS...

Excel COLUMN Function

We can use the excel COLUMN function to return the column number for a reference. Column function returns columns as numbers. For instance, Column B is 2 and Column C is 3. Without a reference, COLUMN function will return the column number of the cell containing the formula. The steps...

Excel ADDRESS Function

You can use the Excel ADDRESS function to get the address for cells in a worksheet, based on particular rows and columns. This function returns an address either in a relative or absolute format. This article provides a clear guide on how to use the Excel ADDRESS function. Figure 1....

Excel MATCH Function

When we want to get the exact position of a given value in a column, row or table, we can use the Excel MATCH function. To fully understand how the function works, please read this post to the end. Figure 1: Using Excel MATCH function to find relative positions General...

Excel TRANSPOSE Function

We can use the Excel TRANSPOSE function to ‘flip’ the orientation of a given range or array. This function changes the horizontal range to vertical or vertical to horizontal range. To understand how the Excel TRANSPOSE function works, read this post to the end. Figure 1: How to use Transpose...

Excel INDEX Function

We can use the Excel INDEX function to get the value at a particular position in a given range or array. We can also use this function to retrieve individual values, entire rows or columns. This post provides a guide on how to use the Excel INDEX function to get...

Excel HLOOKUP Function

While working with Excel, we are able to lookup a value from a row across a table and retrieve specific data by using the HLOOKUP function. HLOOKUP provides a quick way of horizontally looking up a value from any list . This step by step tutorial will assist all levels...

Excel CHOOSE Function

Selecting a value from any list can be done by using the CHOOSE function This step by step tutorial will assist all levels of Excel users in the usage and syntax of the CHOOSE function. Figure 1. Final result: Excel CHOOSE function Formula 1: =CHOOSE(D3,"Mercury","Venus","Earth","Mars") Formula 2: =CHOOSE($D3,B$3,B$4,B$5,B$6) Syntax...

Excel COLUMNS Function

While working with Excel, we are able to determine the number of columns of any cell or range by using the COLUMNS function. This step by step tutorial will assist all levels of Excel users in the usage and syntax of the COLUMNS function. Figure 1. Final result: Excel...