Lookup and reference

How to use Excel OFFSET function

Introduction OFFSET function in excel is a reference function. This function is used to refer data from a cell or range of cells to a defined range. The number of rows and columns to be returned is also specified. Reference returned by offset function is in parts: start point, row and column offset and height …

How to use Excel OFFSET function Read More »

How to use Excel LOOKUP function

Introduction LOOKUP function in excel is a lookup and reference function. This function is used to lookup or approximately match data in single column or single row and retrieve value from corresponding column or row. This function has two forms, one is called vector and the other one is called array form. Vector form Syntax …

How to use Excel LOOKUP function Read More »

How to use Excel TRANSPOSE function

Introduction TRANSPOSE function in excel is a lookup/reference function. This function is used to rotate or flip or switch cells and range of cells without duplicating the data. When copy and pasting of data is done, it leads to duplication of data, by using TRANSPOSE function this problem can be avoided. Syntax  =TRANSPOSE(array) Argument Array:  …

How to use Excel TRANSPOSE function Read More »

How to use Excel GETPIVOTDATA function

Introduction GETPIVOTDATA function in excel is a lookup function. This function is used to return specific data from a pivot table. It uses pivot table structure instead of reference cell reference for retrieving data. Syntax  =GETPIVOTDATA (Data_Field, Pivot_Table, [field1,item1]) Argument Data_Field: It is the name of the field entered in quotation marks which contains the …

How to use Excel GETPIVOTDATA function Read More »

How to use Excel MATCH function

Introduction MATCH function in excel is a lookup function. It helps in locating cell number corresponding to a lookup value of a row, column or table. It does this by searching for specific value in a range of cells and returns position of value. For Example, if the range A3:A6 have the values 10, 15, …

How to use Excel MATCH function Read More »

How to use Excel ROWS function

Introduction ROWS function in excel is a lookup or reference function. It provides us with number of rows in an array or reference. We have to enter a range in Excel format and it returns number of rows present in that range. For example row A1:A6 gives 6 as the result.    ┬áSyntax =ROWS(Array) Arguments …

How to use Excel ROWS function Read More »

How to use Excel ROW function

Introduction ROW function in excel is a reference function. It returns the row number of a cell to which reference is made. If we provide no reference than function returns the reference value of the cell in which the function is written. For example =ROW(A9) returns 9 as A9 is the 9th row in Excel. …

How to use Excel ROW function Read More »