Category: Lookup and References
Lookup and references functions, comes with Excel
![Sheet() and Sheets()](https://xlfxs.com/wp-content/uploads/2018/08/sheets2-2-360x270.png)
Sheet() and Sheets()
ANmar August 22, 2018
![FORMULATEXT to show formulas](https://xlfxs.com/wp-content/uploads/2018/03/2018-03-22-02.29.56-2-2-360x270.png)
FORMULATEXT to show formulas
ANmar March 27, 2018
![New function IFERROR, finally](https://xlfxs.com/wp-content/uploads/2017/02/iferror4-e1514248049745-2-360x252.jpg)
New function IFERROR, finally
ANmar December 24, 2017
![OFFSET+MATCH](https://xlfxs.com/wp-content/uploads/2017/06/xlfxs7-2-360x270.png)
OFFSET+MATCH
ANmar June 9, 2017
![MATCH fumction, just a simple search](https://xlfxs.com/wp-content/uploads/2017/02/wp-1487608607320-2-360x270.png)
MATCH fumction, just a simple search
ANmar February 20, 2017
![Links between two workbooks – dynamically using functions](https://xlfxs.com/wp-content/uploads/2016/09/Link1-2-360x270.png)
Links between two workbooks – dynamically using functions
ANmar September 26, 2016
![VLookup](https://xlfxs.com/wp-content/uploads/2016/05/Post1500-e1480708542345-2.jpg)
VLookup
ANmar September 26, 2016
![Extract current (Active) workbook name](https://xlfxs.com/wp-content/uploads/2015/09/cellfilename-2-360x270.jpg)
Extract current (Active) workbook name
ANmar September 14, 2015
![Why I ran from =INDIRECT() function](https://xlfxs.com/wp-content/uploads/2015/04/RanIndirect-2-360x270.jpg)
Why I ran from =INDIRECT() function
ANmar April 6, 2015
![Get column name (columnname as A,B,C, etc) as input inside cell](https://xlfxs.com/wp-content/uploads/2015/04/ColumnName-starting-from-certain-column1-e1543955211915-2-360x270.jpg)
Get column name (columnname as A,B,C, etc) as input inside cell
ANmar April 6, 2015
![Fx to cut long column into two columns](https://xlfxs.com/wp-content/uploads/2012/03/S_0085_021-e1332195047353-2-360x270.jpg)
Fx to cut long column into two columns
ANmar March 19, 2012