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...
Or you could Ctrl+Shift return =IF(A2:R2=A3:R3,S3,"") which makes it into an array version
{=IF(A2:R2=A3:R3,S3,"")}