The equipment desk calls a kit “Out” when someone has it and “Returned” when it is back but awaiting inspection. “Ready” means it can go out again. Put Status in D1 and reserve D2:D15 for entries.

Give the entry rows the same dropdown

In Ulet select D2:D15, open Data → Data Validation and choose Add Rule. Verify the range, set the type to Dropdown, add Ready, Out and Returned, then choose Done. Choose the warning or rejection behavior that fits your process.

The D2:D15 selection shows Ready, Out and Returned in the validation choices.

Illustrated rule setup. Leave D1 as the column header.

Try the last row and a value outside the list

Pick Out in D2 and check that D15 offers the same three values. In a working copy type In transit and verify the chosen rule behavior. Inspect older statuses separately, and extend the range when a new record goes into D16.

A test entry of In transit sits outside the three-choice vocabulary.

Illustrated validation test. Decide whether the team should get a warning or a rejection.

Related Microsoft Excel reference