The best way to do this is to use the Find First Occurrence block, as mentioned here.
That block returns a 0 if the search term is not found and a positive integer corresponding to the row number it was found in if it exists.
1 Like