Hello! I'm new to the forum so correct me if I am wrong or in the wrong location.

Basically I want to do a find and replace for football pool spreadsheet. Only thing is I want to find a team name and change the cell related to the points.

Example: NE vs MIA (NE wins but you picked MIA)

A B
1 [16] [MIA]

So I want to search for all MIA and replace all 16s with a zero.

Thank you