Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help...Office Excel 2003 IF Function
Hello,
I've figured out how to create a drop down list, now I'm trying to figure out how to assign a specific number to each possibility on the list in the cell next to it. In other words, whenever someone drops down to say "dog", I want a specific dollar amount that I specify to show up next to it. Each name on the drop down list would have only one answer. What's the easiest way to do this? -- Thank You Arsno1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help...Office Excel 2003 IF Function
Have a look at VLOOKUP
Then come back with more questions best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Arsno1" wrote in message ... Hello, I've figured out how to create a drop down list, now I'm trying to figure out how to assign a specific number to each possibility on the list in the cell next to it. In other words, whenever someone drops down to say "dog", I want a specific dollar amount that I specify to show up next to it. Each name on the drop down list would have only one answer. What's the easiest way to do this? -- Thank You Arsno1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening an Office 2003 Excel doc with Office 2000 NT | Excel Discussion (Misc queries) | |||
Opening an Office 2007 Excel file in Office 2003 | Excel Discussion (Misc queries) | |||
function wizard on office 2003 | Excel Worksheet Functions | |||
Office 2000/Office 2003 Excel not printing landscape vise versa | Setting up and Configuration of Excel | |||
Unable to access the Office Online Web site in Office 2003, Excel | Excel Discussion (Misc queries) |