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
- Hi Joseph
Thanks for the feedback. I'm simple on solutions where possible. No matter which option you run with from the suggestions, it's important that you are happy with they result and can work with the formula moving forward.
Glad we were able to give you a couple of options.
If your query is resolved, I would suggest that you flag the best response so this topic is closed for other users future reference of what we have discussed.
Best wishes on your Excel journey!
Cheers
Damien