Hello friends!
I have a data in the excel (example):
I need to find a value from column A and extract coressponding value from Column B same row.
For example:
First run i will input value: “100” it will find a value in datatable and give me output of “Michael”
Second run i will input value: “300” it will output “Chris”
The solution with the Select method will work, but starting with UiPath Studio 2018.2 a new activity was introduced specially for this situation - Lookup Data Table.
You need to configure it this way:
Input → DataTable = the output datatable from ReadRange
Input → LookupValue = “100” or “300” - the value you want to find in first column