How do I ??? - two drop down lists

G

Guest

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?
 
P

Pete_UK

Try this, Jock:

=IF(AND(I7="",J7=""),"",IF(AND(I7<>"",J7<>""),"warning",IF(J7="",
(VLOOKUP(I7,CodeList,2)),VLOOKUP(J7,Wo­rk_Type,3))))

Hope this helps.

Pete
 
G

Guest

Brilliant.
Thanks Pete
--
Traa Dy Liooar

Jock


Pete_UK said:
Try this, Jock:

=IF(AND(I7="",J7=""),"",IF(AND(I7<>"",J7<>""),"warning",IF(J7="",
(VLOOKUP(I7,CodeList,2)),VLOOKUP(J7,Wo-rk_Type,3))))

Hope this helps.

Pete
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I write this formula 1
Drop Down Lists 1
Drop Down with dynamic named range offsheet source list 14
drop down list 1
Drop Down lists 2
Formatted cell column in drop down list 1
multiple dependent drop down lists 6
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6

Top