Lookup and reference Articles: Excel and Google Sheets

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

The INDIRECT function in Excel offers a great way to extract references from a string of text. The greatest advantage of INDIRECT is the reference is unchanged even if we add new columns. We can add as many rows and columns needed in the worksheet and it will not affect...

Excel users often face the phenomenon of performing calculations on cells having a relative distance from other cells. In these situation, the OFFSET function comes in very handy. It returns a cell or range or cells that are a specified number of rows and columns away from a cell or...

The Excel LOOKUP function returns a value from a range of cells (one column or one row) or an array (multiple rows and columns) based on the approximate match as per the Vector or Array syntax. In this article, we will learn how to use the LOOKUP function with the...