| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement
I need a solution for the example below please,
A1 could hold value 9.5, 7.5 or 0 If A1 =9.5 then I need A2 to show a drop down validation list which is also at V1. If A1=7.5 then I need A2 to show a drop down validation list which is also at V2. If A1=0 then I need A2 to show a drop down validation list which is also at V3. Basically I need to copy an exsisting validation list from V1,2 or 3 depending on the value of A1. Any help is appriciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement? | New Users to Excel | |||
| how do I fix my 'if' statement? | Excel Worksheet Functions | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Threaded Mode
