Excel to find a name in a column and if found place a tick in sheet 2.....
 

Hi there,

I have two sheets within a spreadsheet,


One sheet contains a list of names and the other contains/should
contain data relating to those names.


Within sheet 1 I have a column with not only the word "Name" in it as
there is data below that.


In sheet 2 I have a list of names.


I want excel to check if sheet one column F contains the word Name then

it will check if the name next to that cell in Column G matches the
control sheet.


The name of the person will appear more than once in the sheet hence I
want it to search down a column.


If it is found place a tick next to the name in sheet 2 and if not
place a cross next to the name.


Let me know if anyone can help.


Many thanks for your help in advance.


Stuart