I am trying to get a loop to return a value (Previous or Current) when looking through a column. My coding is returning "Previous" when it should be "Current" and vice versa. Also, I am trying to get it to return a value (Current) if a string of text in a cell contains the word "Error".
So if...