google sheets script find cell by value code example

Example: get cell value from string google sheets

=CONCAT("value is ", C5)