Can a form be used to lookup a sheet and provide a result

Hi - I would like to set up a process whereby I can record the purchase of assets (contained in a sheet as a catalog). I want to then store the purchased asset in a sheet. Ultimately, I may also want to sell the asset.

It would be great if there is a template set that can do this or if someone else has done something similar.

Answers