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

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

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

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 -