Excel applications for a Barcode scanner

[Guest]

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

 

[Guest]

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

http://groups.google.com/group/micr...=barcode+group:*excel&rnum=2#3051de63b0c1c6c2

 

[Guest]

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

 

[Guest]

O.K.

Be sure that when you get the number corresponding to the Code that Excel
does not truncate extra digits.