Given this Excel file, we want to retrieve the value corresponding to a given index.
I used the Read Range Activity. Be sure to check the “Add Headers” property of the Read Range activity in order to be able to use column names later in your automation. Also, I used the workbook retrieved by the Open Workbook activity; the data is stored in a datatable.
This is a simple assignment operation where we can change our lookup index: