Lookup Range
Last Updated: Dec 1, 2020
Last Updated: Dec 1, 2020
Use this function to check if a value exists in the specified range and return the address of the cell where the value exists.
Lookup Range (search_range, lookup_value)
| Input Parameter Name | Description |
|---|---|
| search_range | Two cell values (first cell and last cell) separated by ‘:’ to search the value |
| lookup_value | The value to be searched |
| occurrence | Occurrence of the value |
| Return value | Description |
|---|---|
| Position | Returns the position of the cell |
Lookup Range (C3:F8, key, 2) => C5
To view all the Excel functions, click here.