I've to keep track of restaurants' opening times on bank holidays. I have a spreadsheet that takes data from our API which gets updated several times a day. Then I have another column, where I'd like to input manually whether said restaurant is open/closed.
Since the restaurant list updates several times a day and the opening column is static, this doesn't work. I want to tie the opening time to the restaurant's unique ID, so when the data from the API refreshes, the manually input data goes with it too.
Columns A-C are dynamic, D is where I want to track if they're open or not.
E.g.: Restaurant with ID 13 moves to the place of ID 18 because the restaurant goes inactive, I want "Closed" from column D to go with it. If D remains static it would say "Open", which is incorrect.
I'm probably just bad at Googling, but I couldn't figure out how to do this.
Note: I'm trying to do this in Google Sheets.