For some reason, that isn't returning a good value (it says No even
when it should say yes). I apologize for being too vague - the AAA's were
just a place holder for a 9 digit code of letters and numbers (for example:
01245AP91).

Also, the codes could be anywhere in the column, not necessarily B1 and C1
would be the same code. B1 and C5 might be the same, and i'm looking if the
number next to B1 and C5 are the same.
I hope you're still able figure out something for me :)
Thanks,