Formula creation...if possible
 

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!

Formula creation...if possible
 

Do you have a list of the bar code info and the description? If so, you
can use VLOOKUP to get what you want.

"Kelly C" wrote in message
...
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!

Formula creation...if possible
 

Provided you have a master list of part numbers and descriptions somewhere
you should be able to use VLOOKUP to get the description for an input part
number

Regards

Trevor


"Kelly C" wrote in message
...
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!