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

  • Thread starter Thread starter monsoonkhan
  • Start date Start date
M

monsoonkhan

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.
 
Back
Top