Hi

I need to make a sheet which has activities and sub activities. Each
activity has 4-5 sub activities.

I want to find how do i use the if or the vlookup function so that once user
selects a particular activity in a from a drop down list in a cell the
corresponding column will automatically show a another drop down list for the
sub activities related to the chosen main activity.