Formula creation...if possible

K

Kelly C

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!
 
B

Barb Reinhardt

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

Trevor Shuttleworth

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
 
Top