I am creating a spreadsheet which will be used as a template for work requests that will be printed. I am wanting to make the process of entering information onto the sheet much easier.
What I want to be able to do is add data onto one cell and have the next cell automatically populate with related data. For example, when I add an item number onto cell A1, cell B1 will then automatically populate with the description of the item number. The cell names being used is Item Number, Description, Total, and Unit of Measure. I am hoping to find a way that will automatically populate the Description and Unit of Measure cells according to Item Number. I hope this makes sense.
Is this possible? I have no clue what this process is called, therefore, I have had a difficult time finding any tutorials or videos for this. Any help will be appreciated.
Thanks!
Bookmarks