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