Locate Value

This step is used when you have a certain value and you are interested in which cell in a specified range that value is saved. There are three parameters that you have to specify:

  • Cell Djeeni name: Djeeni name with the absolute address of the cell where the value that you were searching for was found. You can refer to the found cell, column or row number later in other steps by using '|cell', '|column' or '|row' additions.
  • Search for value (formula): Value that you are searching for. It can be specified either explicitly (“green”) or with an excel/djeeni formula.
  • Within range: The range within which you want the search to be conducted.

Like it is mentioned above, the found cell address is saved in the Djeeni name of the process step. You can later refer to it using the following syntax:

#ceDjeeniName|cell  - referring to the found cell
#ceDjeeniName|column  - referring to the column number of the found cell
#ceDjeeniName|row  - referring to the row number of the found cell

Note: If the value is not found in the specified range, the execution of the process will be stopped.

Example: You are searching for a cell with value “8” within the worksheet with “wsTest” Djeeni name in the “A1:A5” range. Then you want to replace that value with “16”.