I have a follow-up to this. Perhaps macropod will see it and be kind enough to comment.


I have a cell that contains the text "Published". I want to update the cell just to the right of it.


Unfortunately, there is another cell in the same table that also says "Published." In that case, it's a key, not a value, so I don't want it updated.


In other words:


first row : | published| jan 1, 2021 |
second row: | status | published |
third row: | type | ABC |


What I want to do here is to change the date.
So basically, I want to find the cell in the leftmost column with the word "Published" in it, and then I want to do an offset of (0,1) to go one cell to the right, and change the value there.


If there's another way to think about this, then I can provide more information. For example, I could name the coordinates of each cell involved. They will always be the same.