I need to use loopup value to find a value in a second excel and then write a value in a specific cell in the row containing the searched value

I need to use loopup value to find a value in a second excel and then write a value in a specific cell in the row containing the searched value

1 Like

Hey @Soudios

You can do this in two ways,

  1. Linq

  2. For-each row (twice)

Thanks
#nK

@Soudios

You can try with Lookup Datatable activity

Hope this will help you

Thanks

i used lookup but i can just search the information on excel 2 not write

what i need is :

Excel 1 :slight_smile:
image

Get information on “A1”, so i am searching ''Jo"

Excel 2 :
image

There is the same value on excel 1 and 2 on “F2”

So now when the bot find the same information from excel 1 on excel 2 i want to write “OK” on “E2” for this example, but it can be “E23” if the value i search is in row 23