I’m trying to search a google spreadsheet for a specific word and have it return the row number of every cell containing that word. What I am aiming to do is have 2 lists that contain the rows of cells containing two different keywords, compare the two, and return the common rows.

how would I replicate a python while function it sheets, for reference or if this has a simpler solution the code if in python would look like this:
​