Hello everyone. I am selling about two dozen health and fitness products for my business. I was hoping there was a way I could use excel to save time when calculating and adding up prices.

What I wanted was a way to type the name of a product in excel in colum A and have excel automatically enter the price for that product in colum B. I would need this feature to happen for about two dozen products.

Is there a way to make this happen and can someone please walk me through the process. Thanks so much in advance for your help and feedback.

Jawaune