Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting Results with a Validation List
Hello and thank you for your help. Hopefully, I can explain what I am looking
for and it is a simple formula! I have a drop down list in cell B3 (example: list is apple through zebra). In cell O3, I would like a certain percentage show in the O3 cell when the user selects their choice in cell B3. So if the user selects APPLE then the percentage pertaining to APPLE would appear in the O3 cell. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting Results with a Validation List
Hi,
And how would this percentage pertaining to apple be calculated? Mike "RJ Swain" wrote: Hello and thank you for your help. Hopefully, I can explain what I am looking for and it is a simple formula! I have a drop down list in cell B3 (example: list is apple through zebra). In cell O3, I would like a certain percentage show in the O3 cell when the user selects their choice in cell B3. So if the user selects APPLE then the percentage pertaining to APPLE would appear in the O3 cell. Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting Results with a Validation List
No need to calculate a percentage. Example Apple = 5% Bear = 7% Zebra = -.5%
if the user selects Apple there is just a set percentage associated to Apple or Bear, etc.. "Mike H" wrote: Hi, And how would this percentage pertaining to apple be calculated? Mike "RJ Swain" wrote: Hello and thank you for your help. Hopefully, I can explain what I am looking for and it is a simple formula! I have a drop down list in cell B3 (example: list is apple through zebra). In cell O3, I would like a certain percentage show in the O3 cell when the user selects their choice in cell B3. So if the user selects APPLE then the percentage pertaining to APPLE would appear in the O3 cell. Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting Results with a Validation List
Sounds like you need a lookup table:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "RJ Swain" wrote in message ... No need to calculate a percentage. Example Apple = 5% Bear = 7% Zebra = -.5% if the user selects Apple there is just a set percentage associated to Apple or Bear, etc.. "Mike H" wrote: Hi, And how would this percentage pertaining to apple be calculated? Mike "RJ Swain" wrote: Hello and thank you for your help. Hopefully, I can explain what I am looking for and it is a simple formula! I have a drop down list in cell B3 (example: list is apple through zebra). In cell O3, I would like a certain percentage show in the O3 cell when the user selects their choice in cell B3. So if the user selects APPLE then the percentage pertaining to APPLE would appear in the O3 cell. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Filtered Results for Data Validation | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Validation of results | Excel Discussion (Misc queries) |