I'm trying to figure out what the formula would be to create an auto "paste"
of information on a spreadsheet. Example: on an inventory spreadsheet I use
a bar code scanner to record products we receive, when I scan that product a
part number will appear. I want to create a formula (if possible) to
automatically paste the description of that part number in the column next to
it. Can this be done and if so...HOW? Any help would be greatly appreciated!