Look Up Range activity is not working where Excel is not installed. Are there any other activities like Look Up Range in workbook?
- Read the workbook with Read Range[Workbook]activity and store it in Datatable
- Try Lookup Data Table activity.
This activity helps to search for a provided value in a specified Datatable and returns the RowIndex at which it was found. This activity can also helps return the value found in the cell that has the row coordinates specified in the RowIndex property and the column coordinates specified in the Target Column property category.
More information can be found in Lookup Data Table documentation.