Forum Discussion
Comparing two ranges of cells in an if function
I have two rows of address information that I have to compare. If cells A-R in row 2 are identical to cells A-R in row three then I want cell S inn row three two be returned if true and blank if fal...
Hi Joseph
I am sure I'll think of a better way to do this but for now this will work:
=IF(AND(A2=A3, B2=B3, C2=C3,D2=D3,E2=E3,F2=F3,G2=G3,H2=H3,I2=I3,J2=J3,K2=K3,L2=L3,M2=M3,N2=N3,O2=O3,P2=P3,Q2=Q3,R2=R3), "True", "False")
No matter what you change from A2 to R3, the formula will pick it up.
Nice and simple.
Cheers
Damien
This one works. I just have to make the True one S3.
Thank you