| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I ??? - two drop down lists
I have posted this before but I couldn't get the correct result.
I have two drop down lists (columns I & J). One has numeric codes for fee bearing work, whilst the second has numeric codes for non-fee bearing work. Depending which one is selected by the user, a line of text will appear in K explaining what the work is. I would like to change the following formula (located in K): =IF(AND((I7=""),(J7="")),"",IF(J7="",(VLOOKUP(I7,C odeList,2)),VLOOKUP(J7,Work_Type,3))) to display a warning in K if BOTH I and J have values. Perhaps there's a code way of doing this which will be easier Any ideas? -- Traa Dy Liooar Jock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Drop Down Lists | Excel Worksheet Functions | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| drop down lists | New Users to Excel | |||
Threaded Mode
