I want to find a particular value in column A and have to take corresponding coloumn B value and copy in other location

i have 2 coloumn in on excel sheet , i have to build a bot and find a search for bangladesh taka and take the corresponding rate in coloumn 2 as output.

Please help me to design this bot

Currency Rate
US Dollar 3.6725
Argentine Peso 0.061423
Australian Dollar 2.490844
Bangladesh Taka 0.043308
Bahrani Dinar 9.740346
Brunei Dollar 2.690279
Brazilian Real 0.873054

1 Like

Hi @senthil.it89,

Welcome to UiPath Community Forum!!!

Please read excel content into a datatable. Then you can use filter datatable activity to get the specific row based on column A (currency) value and extract corresponding column B (rate) value.

Hi many thanks for the reply , could you help me with sequence or video sample .would be much appreciated.

Hi
Welcome to uipath community
Hope these steps would help you resolve this
—-use a assign activity like this
str_input = “Bangladesh Taka”
Where str_input is a variable of type string
—use excel application scope and pass the file path as input
—inside the scope use read range activity and get the output with a variable of type datatable named dt
—now use for each row loop and pass the variable dt as input
—Inside the loop use lookup datatable activity
Where mention these property
Input = str_input.ToString
Datatable = dt
Lookup ColumnName = “Currency”
Out Result = str_output
Target column name = “Rate”

Where str_output will be our output
Cheers @senthil.it89

1 Like

Thanks nanba

1 Like

Yendrum natpudan …
@senthil.it89

1 Like

Hi @senthil.it89,

Welcome to UiPath Forum Community !

I have developed an activity called “Find”. If finds the value which you are specifying the range or without range. It return the output as string array.

Regards
Balamurugan.S

1 Like

shareme ur watsapp num

Hi balu ,
my scenario is matching value in coloum A should take corresponding row value in coloumn B.

many thanks.

1 Like

Yes . you can do it.

  • Use the Excel Scope which is in the BalaReva.Easy.Activities.
  • Keep the Find the activity and specify the find text and assign the Array String in the result.
  • You can get the CellInfo . Example A10,AL63.

Thank you
Balamurugan.S