Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
barcode scanner | Excel Discussion (Misc queries) | |||
How do I import an Excel Spreadsheet from a scanner? | Excel Discussion (Misc queries) | |||
Filling cell with color using barcode scanner | Excel Discussion (Misc queries) | |||
Can you import data from a scanner into an excel spreadsheet? | Excel Discussion (Misc queries) | |||
I want to use my scanner to copy into excel. How do I do it? | Excel Discussion (Misc queries) |