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
i used lookup but i can just search the information on excel 2 not write
what i need is :
Excel 1
Get information on “A1”, so i am searching ''Jo"
Excel 2 :
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