Lookup Functions
SheetX provides lookup functions that help you search for values and determine whether specific data exists within a range.
Functions Overview
| Function | Description |
|---|---|
| SX_CONTAINS | Checks whether a value exists within a range. |
SX_CONTAINS
The SX_CONTAINS function checks whether a value exists within a specified range. It returns TRUE if a match is found and FALSE otherwise.
Syntax
text
=SX_CONTAINS(cell_or_range_query, search_range)Arguments
| Argument | Description |
|---|---|
cell_or_range_query | A value or a range of values to search for. |
search_range | The range containing the values to search against. |
Use Cases
- Verify whether an entered value exists in an approved list.
- Determine whether a product appears in a list of available items.
- Verify whether records from one dataset exist in another.