Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation & Conditional Formatting
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". |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation & Conditional Formatting
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". Not sure this has anything to do with either "Data Validation or Conditional Formatting". Maybe this will help: http://www.contextures.com/xlFunctions02.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation & Conditional Formatting
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". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Conditional Formatting....or both? | Excel Worksheet Functions | |||
Data Validation - Dependent Lists & Conditional Formatting | Excel Worksheet Functions | |||
Finding data validation and conditional formatting | Excel Discussion (Misc queries) | |||
Data Validation & Conditional Formatting | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) |