J
Jock
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,CodeList,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?
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,CodeList,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?