Data Validation & Conditional Formatting

[bleitner2008]

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".

 

[Glenn]

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".

Not sure this has anything to do with either "Data Validation or Conditional
Formatting".

Maybe this will help:

http://www.contextures.com/xlFunctions02.html

 

[Shane Devenshire]

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