PLEASE HELP!! NEED QUICK ANSWER AS HAVE TO HAND IN SPREADSHEET ASA
 

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.

PLEASE HELP!! NEED QUICK ANSWER AS HAVE TO HAND IN SPREADSHEET ASA
 

=IF(COUNTIF(Sheet1!A3:A20,"smith")0,"yes","no")

--
Gary''s Student - gsnu200835


"monsoonkhan" wrote:

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.