We have a Google Sheet where we keep "active" info vs "archive" info. We want to make sure the columns match up on both tabs so we can just do a cut-n-paste when we're moving data from Active to Archive.
I'm using this formula because we're trying to match up multiple columns at once: =if((transpose(Query(transpose(B1:C1),,9^9))=transpose(Query(transpose(archive!B1:C1),,9^9))),"ok","not")
Here's the weird thing: formatting seems to make a difference?!?
Please see my example on this GS:
REFERENCE
For more information, you may read the documentation below: