Incrementing Rows or Colums After Running Through an IF Statement
 

I am trying to check two lists of names against each other. I would like to
check the first name in list one against all of list two. Once that is
finished I would then like to increment to the next person in list one and
repeat the process. Is there a way that I can set the number after a column
(A"#") as a variable that I can change?

Incrementing Rows or Colums After Running Through an IF Statement
 

Suppose you have the two lists in Col A and ColD and you are comparing each
name in Col A with ColD. In col B CELL B1 place the formula

=IF(COUNTIF(D:D,A1)0,"Present in List","")

Once done. copy the formula down to colA...The formula will adjust for each
name in Col A..

If this post helps click Yes
---------------
Jacob Skaria


"Intern" wrote:

I am trying to check two lists of names against each other. I would like to
check the first name in list one against all of list two. Once that is
finished I would then like to increment to the next person in list one and
repeat the process. Is there a way that I can set the number after a column
(A"#") as a variable that I can change?