Excel Lookup & Reference functions

Hello. Enough of introduction posts. Let's jump to see how to increase number crunching efficiency in Office which is the purpose of this blog. We will start with most used functions in day to day office work which are lookup and reference functions.

I use lookup functions very frequently. These functions are used to locate a value you are looking for in a set of rows and columns and returns it's address or corresponding value in any other column. 

Excel offers below functions under 'Lookup & Reference' category. (In Excel 2003, 2007, 2010)

• ADDRESS
• AREAS
• CHOOSE
• COLUMN
• COLUMNS
• GETPIVOTDATA
• HLOOKUP
• HYPERLINK
• INDEX
• INDIRECT
• LOOKUP
• MATCH
• OFFSET
• ROW
• ROWS
• RTD
• TRANSPOSE
• VLOOKUP

These functions makes life a lot easier for accountants. I use them for tax calculations, merge monthly budget figures to year end report, We will cover these functions over series of posts from now on. Stay tuned.