View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GerryD_62 GerryD_62 is offline
external usenet poster
 
Posts: 1
Default How do I create "IF" function with a drop down list?

I have a worksheet with an option for a user to choose "0" to "3" in a cell
with a drop down list. Where "0" = N/A, "1" = NI (needs improvement), "2" =
No, and "3" = Yes. This option is located in cell "E16". What I want to do
is create an option for a new drop down list in adjacent cell "G16" which is
based upon the choice made in "E16". A user could choose from several
different appropriate answers for either "3", "2", "1", or "0".