Home > Net >  Google Sheets trying to match multiple columns but the results make no sense
Google Sheets trying to match multiple columns but the results make no sense

Time:07-10

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: enter image description here

REFERENCE

For more information, you may read the documentation below:

  1. enter image description here

  • Related