google sheets formula cell value text code example

Example 1: match cell with the value google sheets

=MATCH("Sunday", A2:A9, 0)

Example 2: get cell value from string google sheets

=CONCAT("value is ", C5)