google sheets get cell value if other cell equals code example

Example: match cell with the value google sheets

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