So an assignment fell in my lap at work that is a little out of the ordinary for my skill set. My boss wants to create a google sheets data base to track our rental equipment. I created a handful of data validation Columns to track Unit#, Customer Location, Maintence required, etc. Example
Unit Location Maint 321266 128 Oil Change 322267 600 None 323264 950 Bad Breaks
I've locked the Unit and Location to only allow the correct info to be input and allowed Maint and other fields to be input manually because they vary to much to be validated.
Now I need to spruce it up and turn it into a working spreadsheet, not just rows of info. Is there a way I create a new sheet so when I imput data into a cell that is data validation locked to only accept correct Unit numbers, and then auto populate the location/maint/etc columns?
Say I type in 323264 in a cell on a second sheet, i want it to fill in 950 and bad breaks into the next two cells.
Is this possible or am I barking up an empty tree? I've searched through the stacks for awhile and found lots of ways to pull data from one sheet to another, but not pulling data tied to one cell when that cell moves throughout the spreadsheet.