Next Cell Location in Excel

[Soumya_Chatterjee]

I am new in the UI Path, need some help to automate a manual task.

Billed and Net amount need to be updated in another excel by searching No’s.
I used For each row-find from excel activities to find No’s position/cell index (A2,A3, etc.) in 2nd excel. both excel can not be sorted so position can be any where. I need to know how i can place Billed and Net amount in next to cell of No in 2nd excel.

Variable “Position” data type used as String and when placing +1 to update the value in next cell. getting error. Please help.

[Kartheek_Battu]

Hello @Soumya_Chatterjee

For Each Row (in First Excel)

Read data from the current row
No = row("No").ToString();
Billed = row("Billed").ToString();
NetAmount = row("Net Amount").ToString();

Find the row in the second Excel file based on "No"
Position = FindNoInSecondExcel(No);

Update "Billed" and "Net Amount" in the second Excel file
WriteToSecondExcel(Position, Billed, NetAmount);

Thanks & Cheers!!!

[Soumya_Chatterjee]

can you please show me the process in a flow, like i have in screenshot. new to coding

[Kartheek_Battu]

@Soumya_Chatterjee

[lrtetala (Lakshman Reddy)]

Hi @Soumya_Chatterjee

Please find the below xaml for your reference

BlankProcess15.zip (72.0 KB)

Hope this helps!!

[AJ_Ask]

Hi @Soumya_Chatterjee

You can use this simple method of Vlookup to get this done

Use the Vlookup activity

Find attached the flow for your ref:
Vlookup.zip (16.2 KB)

You can also watch this video this explains beautifully how the vlookup works.
https://youtu.be/LxVuNHKS540?si=1Kt7jo3AC6s0i5zN

Hope this helps