How to find the next cell value if the previous value is known

Hi guys,

I have a query.

How to find the next cell value in a excel file if the previous value is known

In this excel file suppose I have the value “Rishabh”.

Demo-2.xlsx (8.6 KB)

How can I get the value “Sardul” ??

Logic should be dynamic.

Regards
Nirmalya

Hi @nirmalya.sarkar

Here is the workflow

Sequence.xaml (8.4 KB)
Demo-1.xlsx (8.6 KB)

Regards
Gokul

Hi @nirmalya.sarkar ,

Try with Get cell Value.

@Gokul001 ,

What is the activity you have used here??

Regards,
Nirmalya

Hi @nirmalya.sarkar

We can try using getting the index value using lookup datatable and by incrementing the index from the index we can get the desired result!

Please refer to the screenshot below!

Uploading: image.png…

Regards

Hi @nirmalya.sarkar

Go to Manage package → update the UIpath.System.Activities

Message Box

Regards
Gokul

@pravin_calvin ,

Please give me the screenshot once again.

It is not showing here.

Regards,
Nirmalya

@Gokul001 ,

By using this flow I am getting all the values under “profession” column.

But my requirement is little bit different.

How to find the next cell value in a excel file if the previous value is known

In column name “profession” the"developer" value is already known. How can I get the “Actor” value using dynamic logic.

Regards,
Nirmalya

Hi @nirmalya.sarkar

Refer to the screenshot below!

Regards

Hi @nirmalya.sarkar

Here is the workflow

Sequence.xaml (8.5 KB)

Regards
Gokul

1 Like

Hi @nirmalya.sarkar

If your query is resolved, Kindly mark the appropriate post as solved.

So it will help for others user

Regards
Gokul

@Gokul001 @pravin_calvin @KODI_SRIHARI

thank you guys for your continuous guide.

Regards,
Nirmalya

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.