Excel Adding a price to data entered

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

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

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