Category: Lookup and References

Lookup and references functions, comes with Excel

Sheet() and Sheets()

ANmar August 22, 2018

FORMULATEXT to show formulas

ANmar March 27, 2018

New function IFERROR, finally

ANmar December 24, 2017

OFFSET+MATCH

ANmar June 9, 2017

MATCH fumction, just a simple search

ANmar February 20, 2017

Links between two workbooks – dynamically using functions

ANmar September 26, 2016

VLookup

ANmar September 26, 2016

Extract current (Active) workbook name

ANmar September 14, 2015

Why I ran from =INDIRECT() function

ANmar April 6, 2015

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

ANmar March 19, 2012