Hi,

Set up a table of the Product - Prices, say in D1:E60, and then in column B
use

=VLOOKUP(A1,D$1:E$60,2,FALSE)

If this helps, please click the Yes button

cheers,
Shane Devenshire

"bleitner2008" wrote:

I'm not sure how to do this...
Column A (I've set up a drop down box of values). Column B I want to be
conditional. For example if Column A is "Product A" then populate Column B
automatically with $5.00. If "Product B" then "$10.00".