Excel Adding a price to data entered

Closed
wayno - Jul 20, 2010 at 06:59 AM
aspperasp Posts 6 Registration date Sunday November 11, 2012 Status Member Last seen December 16, 2012 - Nov 26, 2012 at 08:16 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 20, 2010 at 07:15 AM
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
0
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
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 20, 2010 at 07:35 AM
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
0
aspperasp Posts 6 Registration date Sunday November 11, 2012 Status Member Last seen December 16, 2012
Nov 26, 2012 at 08:16 PM
I guess, you may try to encode the price in the bar codes.
0