How to set up mask validation and value output?

Question

Google Sheets

There is a document in Google sheets, on the first page there is a list of data (ip address, server, port, domain name, key, etc.), on the second page all the keys in the servers are presented, the idea is to check the data by mask on the first page, and in the second, the data opposite the key dynamically changes.

That is, on the first page we write "chamomile", "0.0.0.0" "version 4.3.4" "4554655" (4554655 is the key number), on the second page all the keys are in one column, you need what would be configured, what would be in in the cell to the right of the key 4554655, the inscription "key is busy" appeared, and then in the next cell the name of the company and the IP address appeared (that is, a camomile and 0.0.0.0).

Accordingly, if the line changes with this key or is deleted, then the inscription "key is busy" changes to "key is free" and then the rest of the cells (name and ip address) become empty.

Answer 1

use APP Scripts or make your website two page