Excel applications for a Barcode scanner
 

Currently, I am able to scan barcodes from a scanner which opens up an Excel
file and verifies the UPC code on the product. What I need to do is set up a
table that will then show the price equated with the UPC. I'm thinking a
VLookup would work since I have about 20 UPC I must verify and eqaute to
price. I'm looking for some help in developing a table or formula to do so.
Thanks
John K.
New York, NY

Excel applications for a Barcode scanner
 

You can use VLOOKUP. See Tom's response in :

http://groups.google.com/group/micro...51de63b0c1c6c2
--
Gary''s Student - gsnu200743


"JohnnyK1955" wrote:

Currently, I am able to scan barcodes from a scanner which opens up an Excel
file and verifies the UPC code on the product. What I need to do is set up a
table that will then show the price equated with the UPC. I'm thinking a
VLookup would work since I have about 20 UPC I must verify and eqaute to
price. I'm looking for some help in developing a table or formula to do so.
Thanks
John K.
New York, NY

Excel applications for a Barcode scanner
 

Thanks for the quick response. I think this will work. I'll let you know next
week when I'm back at work.

"Gary''s Student" wrote:

You can use VLOOKUP. See Tom's response in :

http://groups.google.com/group/micro...51de63b0c1c6c2
--
Gary''s Student - gsnu200743


"JohnnyK1955" wrote:

Currently, I am able to scan barcodes from a scanner which opens up an Excel
file and verifies the UPC code on the product. What I need to do is set up a
table that will then show the price equated with the UPC. I'm thinking a
VLookup would work since I have about 20 UPC I must verify and eqaute to
price. I'm looking for some help in developing a table or formula to do so.
Thanks
John K.
New York, NY

Excel applications for a Barcode scanner
 

O.K.

Be sure that when you get the number corresponding to the Code that Excel
does not truncate extra digits.
--
Gary''s Student - gsnu200743


"JohnnyK1955" wrote:

Thanks for the quick response. I think this will work. I'll let you know next
week when I'm back at work.

"Gary''s Student" wrote:

You can use VLOOKUP. See Tom's response in :

http://groups.google.com/group/micro...51de63b0c1c6c2
--
Gary''s Student - gsnu200743


"JohnnyK1955" wrote:

Currently, I am able to scan barcodes from a scanner which opens up an Excel
file and verifies the UPC code on the product. What I need to do is set up a
table that will then show the price equated with the UPC. I'm thinking a
VLookup would work since I have about 20 UPC I must verify and eqaute to
price. I'm looking for some help in developing a table or formula to do so.
Thanks
John K.
New York, NY