Description cell auto fill from Sheet 2?
Hello,
I need some help. I’m trying to build an inventory list of what’s going in and out. My previous job had this spreadsheet where it made inputting item names and descriptions quick. All I had to do was put the part item in a cell and the description for that part item would fill in by itself from all the info from a different sheet. I would like to know how that was done. Thank you!
Example:
On sheet 1. There’s an item tab and a description tab. Let’s say I input “PN50” under the item cell and the description would automatically fill the correct description “Pioneer - 50inch” that goes along with the item.
On sheet 2, i would have all the items and descriptions typed in and ready to go for sheet 1.
[link] [comments]
Want to read more?
Check out the full article on the original site