Lookup Range
Last Updated: Mar 15, 2021
Last Updated: Mar 15, 2021
Use this function to check if a value exists in the specified range and returns the address of the cell where the value exists.
Lookup Range (search_range, lookup_value, occurrence)
| Input Parameter Name | Description |
|---|---|
| search_range | First cell to last cell value 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)
To view all the Excel functions, click here.