How to contain string variable in excel if condition

Learn Certification
, , , ,
#1

Hi Guys,

When i contain input dialog string variable in excel if condition , i couldn’t able to contain string in row

I have to attached sample code below,

My expectation below,

when i give input dialog box row value like “AA”, IF condition show True

Input_string.zip (22.5 KB)

please anyone help this,

Regards,
Raja G

#2

Hi,
The problem is If block is out of the foreach row loop
The output value of ‘result’ contains only last row value once it comes out from the loop.
So Solution is place the if condition inside the Foreach row loop and test it once.
If you want to come out from the loop if your search keyword id found, you can give the break activity in if loop

Hope it works… Mark as solution if it resolves

1 Like
#3

Thank you so much…Mark as solution if it helped :slight_smile: