| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically fill cell value
I have a drop down list in a cell. If the user selects "Euro" from the list,
how do I get cell B7 populated with the value 80 automatically. If they select "STD" then cell B7 would need to be 100. I have the values stored in the worksheet. Is it possible to fill this in automatically depending on the user selection, if so can some one please tell me how. Thaks andy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically fill cell value
Hi ingalla
You can use a VLookup formula See http://www.contextures.com/xlFunctions02.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ingalla" wrote in message ... I have a drop down list in a cell. If the user selects "Euro" from the list, how do I get cell B7 populated with the value 80 automatically. If they select "STD" then cell B7 would need to be 100. I have the values stored in the worksheet. Is it possible to fill this in automatically depending on the user selection, if so can some one please tell me how. Thaks andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically fill blank cell by same as just above record | Excel Discussion (Misc queries) | |||
| set up a formula to automatically fill down from previous cell | New Users to Excel | |||
| how do I program a cell to automatically fill in today;s date? | Excel Worksheet Functions | |||
| How do I automatically fill a cell based on another cell in Excel | Excel Discussion (Misc queries) | |||
| Automatically fill one cell in any newly inserted row | Excel Discussion (Misc queries) | |||
Hybrid Mode
