View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dlotz@uafc.com is offline
external usenet poster
 
Posts: 83
Default validation drop down list question

ok Let say I have 5 col.
Col A I have a drop down list with 5 possible selection
Col B I need a formula that will produce an additional
drop down list based onthe data in A
Col C Vlookup from B
Col D vlookup from B
Col E vlookup form B


Im fine with the vlookup formulas.
I just want to know how I could selct from a drop down
list in one column and would produce another drop list in the
next column that trigger the vlookup/'s
Hope that is not too confusing
Please advise