Excel Adding a price to data entered

[Closed]
Report
-
Posts
6
Registration date
Sunday November 11, 2012
Status
Member
Last seen
December 16, 2012
-
Hello, here's my problem, I have a scanner which I scan my product with and it enters the product into a cell and I want excel to be able to recoginise the part and add a price to it could someone please help me with this problem!!
Thanking you in advance



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
it seem that you would need to use a VLOOKUP. This I am saying presumption that you have a list where the scanned code and the price is listed already and in in excel format
Hi thanks for you response but no maybe I have explained wrong lets ignore the scanner part because I have created my own barcodes so therefore all that is is a means to not type in the product so let's just say I type in my product for e.g Clipsal powerpoint in a1 I want to put a list of prices for diffrent products in column B and I want excel to recoginise what product I have typed in column A line it up with the correct price in cloumn B and answer it in column c
Thankyou
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
What I am trying to say is that you need one master list of items and their prices. Once you have that master list that master list can be used to see what should be the price of item that you have just entered into sheet. Some where, some one need to tell the system that item "Clipsal powerpoint " cost X amount ( per unit ). Once that information is there, then one can use that knowledge

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
Posts
6
Registration date
Sunday November 11, 2012
Status
Member
Last seen
December 16, 2012

I guess, you may try to encode the price in the bar codes.