Google sheets - get row ID where value is

[ondracehak1]

Hi! I really need your help i dont know how get id of row, where is specific value. I am using google spreadaheet

Example:

My_id | Value

6283 | yes
2891 | Yes
3728 | Yes

And now, i want to change row with My_id = 2891 to value “no”. But i cant do that, because there is no any function, to change value of “my_id” row, just origin row ID . Do anybody know, how to get row ID , if i know “my_ID” ? Thank you so much

[muneer]

There is NO ready block for that. You need to create your own function or use it through the DVL (Data Viewer List).

[Hayder]

@ondracehak1

how to get row ID

Hello buddy!
There are many workarounds that make you get the row ID. Would you explain more what are you going to do so we can help you with more details.

My regards
Hayder

[codeswept]

Here you go:

https://x.thunkable.com/copy/8523cc5127967563a1a957ad30c29f9b