Category: Lookup and reference

Functions

Excel MATCH function

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

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

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

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

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