| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
What function to use? Data Validation or IF
I am trying to set up a spreadsheet that allows you to type text in cell A1
and it will automatically enter a dollar amount into cell B1. The text in A1 could be a number of options so a drop down box would be good to select from but then how will this be able to place the corresponding dollar amount in B1. eg. A1 - Sydney, LAX, Melbourne, London B1 - 960, 10000, 1200, 15000 If you know an user friendly way of putting this information in, please help! Thanks Allie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validating a name without using the Data Validation function | Excel Worksheet Functions | |||
| data validation - indirect function | Excel Discussion (Misc queries) | |||
| Data Validation Function Help | Excel Worksheet Functions | |||
| DATA VALIDATION with LEFT function | Excel Discussion (Misc queries) | |||
| Validation function under DATA Menu | Excel Discussion (Misc queries) | |||
Threaded Mode
