i have a list of names is a spreadsheet in cell a3-a20.

i have a nother spreadsheet and i want to create a formula in it that says
if any of the cells in the other spreadsheet range a3-a20 contain the name
smith for example, it will return the value yes, if not, no.