| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable Value Function Help?
Here is what Im trying to do. In cell B2 I have List Validation that has
a source of: "Local Buy, Mass Media Buy". In cell A2 I want the value to change based on what i choose in cell B2. What I'm aiming for is when i select "Mass Media Buy" in Cell B2 then I want Cell A2 to =B14 and when I select "Local Buy" in cell B2 I want cell A2 to =B19. I have tried using SUMIF, LOOKUP, and nested IF Functions, none of them seem to work for what Im coming up with. I know it is possible, but my logic is faulty with this issue. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a variable in the Range function | Excel Worksheet Functions | |||
| Variable Sum Function | Excel Discussion (Misc queries) | |||
| Variable function | Excel Discussion (Misc queries) | |||
| Variable function | Excel Discussion (Misc queries) | |||
| Variable function | Excel Discussion (Misc queries) | |||
![Jonathan Cheek[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
