Excel Lookup & Reference Functions:

Explained with Examples.

  • OFFSET: OFFSET is a Logical Function. OFFSET formula is very useful to travel in the Worksheet and fetch a specific range from particular Cell or Range. 
  • COLUMN: COLUMN is a Logical Function. COLUMN Function in Excel returns the column number of the given reference
  • ROW: ROW is a Logical Function. ROW Function in Excel returns the row number of the given reference.
  • CHOOSE: CHOOSE is a Logical Function. Choose function helps us to select a particular value from list of values. Or selecting particular cell or range from a range.
  • INDEX: INDEX is a Logical Function. INDEX Function in Excel returns either the value or the reference to a value from a table or range.
  • MATCH: MATCH is a Logical Function. MATCH function is just opposite to Index Function. Index returns a match value for a given index from the range.
  • HLOOKUP: HLOOKUP is a Logical Function. HLOOKUP is helpful to get the values from the lookup range, it search from top to bottom in Horizontal approach.
  • VLOOKUP: VLOOKUP is a Logical Function. VLOOKUP looks for the lookup_value in vertically in a given array and results the respective value from the specified column.
  • LOOKUP: LOOKUP is a Logical Function. LookUp function is helpful if you want to look up a value in either in one-row or one-column data range or any array.

Hey! Join Our Community

Get Quick Responses & Experts' Answers in Minutes!
Get Notified - When Answered Your Question!