---
title: "2-Way sync between sheets without a unique ID"
author: "Brian Bennett"
date: 2021-12-03T08:58:32+00:00
modified: 2021-12-03T09:01:49+00:00
canonical_url: https://pulse.appsscript.info/p/2021/12/2-way-sync-between-sheets-without-a-unique-id/
markdown_url: https://pulse.appsscript.info/p/2021/12/2-way-sync-between-sheets-without-a-unique-id.md
categories:
  - "Beginner"
  - "Sheets"
  - "Solutions"
tags:
  - "@FarrisSpencer"
  - "spencerfarris.me"
featured_image: https://pulse.appsscript.info/files/2021/12/maxresdefault-14.jpg
description: "I'm in the habit of adding IDs to sheets where I need to do lookups, but sometimes, I inherit a sheet without IDs in place (or I can't edit the sheet structure). Spencer outlines a clever way to handle syncing between two sheets without using IDs in this video."
---

# 2-Way sync between sheets without a unique ID

![2-Way sync between sheets without a unique ID](https://pulse.appsscript.info/files/2021/12/maxresdefault-14.jpg)

> How to setup 2-way sync within the same workbook without any unique ID.

I’m in the habit of adding IDs to sheets where I need to do lookups, but sometimes, I inherit a sheet without IDs in place (or I can’t edit the sheet structure). Spencer outlines a clever way to handle syncing between two sheets without using IDs in this video.

Source: [2-Way Sync: No Unique ID**](http://spencerfarris.me/2-way-sync-no-unique-id/)

---

*Published by [Brian Bennett](https://pulse.appsscript.info/p/author/brianbennett/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2021/12/2-way-sync-between-sheets-without-a-unique-id/](https://pulse.appsscript.info/p/2021/12/2-way-sync-between-sheets-without-a-unique-id/)*