Category: Lookup and reference

Functions

Excel MATCH function

Jan 09, 2019
390 Views
The ‘MATCH’ function in Excel will return the position of a lookup value within a specified cell range (which can …
Functions

Excel OFFSET function

Aug 18, 2018
744 Views
The ‘OFFSET’ function in Excel will return a cell reference that is a given number of rows and columns away …
Functions

Excel HYPERLINK function

Aug 18, 2018
172 Views
The ‘HYPERLINK’ function in Excel will create a clickable link (to a website, a separate sheet, external file or to …
Functions

Excel TRANSPOSE function

Aug 16, 2018
354 Views
The TRANSPOSE function in Excel enables you to change the orientation of a specified cell range. How to use the …
Functions

Excel FORMULATEXT Function

Aug 13, 2018
175 Views
The ‘FORMULATEXT’ function in Excel will return the formula being used in any given cell in text format. Note that …