I need an expert of Google Sheets

Job ID: 34421482

Budget: $15 – $25 CAD

We have a large fleet of pianos to maintain. The inventory is
in a Google Sheet and we use a Form technicians fill to enter
service items (tune, clean etc). We would need to link the
"serial number" field to validate each entry by referencing the
data to the pianos in the Sheet that contains inventory. Then
we'll need this data to be formatted so the school
administration has easy access. We'll have to talk to better
explain.thank you!