Scenario - the data I have has NULLS, so I need the bot to go row by row in a column and look for the NULLS. I am using an if with a condition of String.IsNullOrEmpty(row(“PreAdminPainScore”).ToString) I read the range > then a for each > I added a Lookup Data Table > then the “if” after that I assign it then write it back into sheet 2. I am missing something.
but when I run it and assign it is gets stuck in a loop. I’m no expert in this stuff.