My mobile teams rely on a spreadsheet for localization. With time I realized that each team are using their own keys rather than using the same one. I need to start from scratch and have both teams use the same key. How can I copy over all the rows that have matching keys into another sheet as depicted here?

enter image description here

so for example in the new sheet I would like to see something like this

identifier       | english             | arabic               | 
credit_card      |credit card          | بطاقة الائتمان        |
cash_on_delivery |cash on delivery     | الدفع نقدا عن الاستلام |

so notice the row where identifier iOS has cash will be ignored because the corresponding key in android label_cash doesn't match it

  • Please add a brief description of your search/research efforts as is suggested in How to Ask, specify if you are looking for a formula or script and add a link to a demo spreadsheet (you might find helpful this [ How to share a Google Sheets demo spreadsheet](webapps.stackexchange.com/q/138382/88163))
    – Rubén
    Feb 19, 2020 at 16:06

1 Answer 1


If your data sheet is in Sheet1 you can use the FILTER function in your other sheet.


Have a look how the FILTER function works

  • Please check the updated answer (following my initial hasty reply) Feb 20, 2020 at 0:51
  • Have you ever tried this answer? Feb 28, 2021 at 5:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.