---
title: Lookups
slug: lookups
docTags: 
createdAt: 2025-09-22T04:56:10.000Z
---

### ADDRESS

**Description: **Returns the address of a cell in a worksheet given a specified row and column numbers.

**Example: **

*ADDRESS(row\_num, column\_num, \[abs\_num], \[a1]. \[sheet\_text])*

### Choose

**Description: **Returns the value from a range of values on a specific index.

**Example: **

*Choose(index, valuearray)*

### Column

**Description: **Returns the column index of the provided column in range.

**Example: **

*Column(range)*

### ERROR.TYPE

**Description: **Returns an integer for the given error value that denotes the type of error given

**Example: **

*ERROR.TYPE(value)*

### Exact

**Description: **Compares two values ignoring the styles and returns the boolean value as true or false.

**Example: **

*Exact(value1, value2)*

### Find

**Description: **Finds a portion of a string from a particular text and returns the location of the string.

**Example: **

*Find(lookfor, lookin, start)*

### HLOOKUP

**Description: **Finds a value in one row and returns the corresponding value in another row.

**Example: **

*HLOOKUP(lookup\_value, table\_array, row\_index\_num, range\_lookup)*

### IFERROR

**Description: **Tests if an initial given value or expression returns an error.

**Example: **

*IFERROR(value, value\_error)*

### IFNA

**Description: **Returns the value specified if the formula returns the #N/A error; otherwise, it returns the result of the given formula.

**Example: **

*IFNA(Formula\_value, value\_if\_na)*

### Index

**Description: **Returns the exact value from the provided row index and column index from a specific range.

**Example: **

*Index(range,row,col)*

### Indirect

**Description: **Returns the reference as a string instead of providing the content or range within it.

**Example: **

*Indirect(content)*

### IsBlank

**Description: **Checks for blank or null values.

**Example: **

*IsBlank(value)*

### IsErr

**Description: **Checks whether a value is an error.

**Example: **

*IsErr(value)*

### ISERROR

**Description: **Returns True if cell holds an error.

**Example: **

*ISERROR(value)*

### ISEVEN

**Description: **Returns True if given number is an even number, and returns FALSE if the given number is odd.

**Example: **

*ISEVEN(value)*

### IsLogical

**Description: **Checks whether a value is a logical value and returns a TRUE or FALSE.

**Example: **

*IsLogical(value)*

### IsNA

**Description: **Returns a boolean value after determining that the provided value is a #NA error value.

**Example: **

*IsNA(value)*

### IsNonText

**Description: **Returns the boolean value after determining that the provided value is not a string.

**Example: **

*IsNonText(text)*

### ISNUMBER

**Description: **Returns True if cell holds a number.

**Example: **

*ISNUMBER(value)*

### ISODD

**Description: **Returns True if given number is an odd number, and returns FALSE if the given number is even.

**Example: **

*ISODD(value)*

### ISREF

**Description: **Returns the logical value TRUE if the given value is a reference value; otherwise the function returns FALSE.

**Example: **

*ISREF(given\_value)*

### IsText

**Description: **Returns a boolean value after determining that the provided value is a string.

**Example: **

*IsText(text)*

### LOOKUP

**Description: **Returns a value either from a one-row or one-column range, or from an array.

**Example: **

*LOOKUP(lookup\_value, lookup\_vector, result\_vector)*

### Match

**Description: **Searches for a specified value in an array and returns the relative position of that item.

**Example: **

*Match(value, array, match\_type)*

### NA

**Description: **Returns the #N/A error when a formula is unable to find a value that it needs.

**Example: **

*NA()*

### Offset

**Description: **Returns a reference to a range that is offset a number of rows and columns from any given range or cell.

**Example: **

*Offset(range, rows, columns, height, width)*

### T

**Description: **Tests whether the given value is text or not, then returns the given text.

**Example: **

*T(value)*

### VARLOOKUP

**Description: **Finds a value in within given key/value pairs

**Example: **

*VARLOOKUP(lookup\_value, \{key\:value})*

### VLOOKUP

**Description: **Finds a value in one column and returns the corresponding value in another column.

**Example: **

*VLOOKUP(lookup\_value, table\_array, col\_index\_num, range\_lookup)*