if statements going to next record 5 times
 

Please help.
I would like to compare information in A1 to AA1 if = I would like to then
compare to the next record A2 If this is = I would like to compare to the
next record A3 If this is = I would like to compare to the next record A4 If
not = I would like to get information from AA2. I can get this to work with
just 1 comparison but how do I get it to look at the next record?