| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I ??? - two drop down lists
Try this, Jock:
=IF(AND(I7="",J7=""),"",IF(AND(I7<"",J7<""),"war ning",IF(J7="", (VLOOKUP(I7,CodeList,2)),VLOOKUP(J7,Wo*rk_Type,3)) )) Hope this helps. Pete On Nov 5, 3:57 pm, Jock wrote: 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,Wo*rk_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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I ??? - two drop down lists
Brilliant.
Thanks Pete -- Traa Dy Liooar Jock "Pete_UK" wrote: Try this, Jock: =IF(AND(I7="",J7=""),"",IF(AND(I7<"",J7<""),"war ning",IF(J7="", (VLOOKUP(I7,CodeList,2)),VLOOKUP(J7,Wo-rk_Type,3)))) Hope this helps. Pete On Nov 5, 3:57 pm, Jock wrote: 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,Wo-rk_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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I ??? - two drop down lists
You're welcome - thanks for feeding back.
Pete On Nov 5, 4:50 pm, Jock wrote: Brilliant. Thanks Pete -- Traa Dy Liooar Jock "Pete_UK" wrote: Try this, Jock: =IF(AND(I7="",J7=""),"",IF(AND(I7<"",J7<""),"war ning",IF(J7="", (VLOOKUP(I7,CodeList,2)),VLOOKUP(J7,Wo-rk_Type,3)))) Hope this helps. Pete On Nov 5, 3:57 pm, Jock wrote: 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,Wo*-rk_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- Hide quoted text - - Show quoted text - |
| Reply |
| 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 | |||
Linear Mode
