Find the row index if a particular keyword is present in a particular Column


#1

Hi,

I want to get the row index of the row which has the status "1. Neu " in “Status” column(L).
I am able to get the status if “1. Neu” by creating a Boolean variable, but unable to get the row index of the same.
Kindly assist.


#2

Have you tried this activity -


#3

Yes, but I need help with searching for the row index for that specific cell


#4

Can I know what output you are getting when using lookup range?


#5

I get a null value


#6

It means is it unable to find the value in the given range.
Can you please check for the value present in the excel.
This activity returns the range string where it found the look up value.

Regards,
Karthik


#7

Can you help me with the logic to get the row index for that row?


#8

I will send you the sample XAML file with 1 or 2 solutions by today evening.

Regards,
Karthik Byggari


#9

Hi Karthik,

Did you manage to get time to look into the solution.

Thanks,
Nikhila


#10

Hi Nikhila,

I am really sorry for not sending you the workflow. I will send you today for sure.

Regards,
Karthik Byggari


#11

Thanks.


#12

TestProcess.zip (30.5 KB)

Output:


#13

Thanks Karthik