Hi

Have a look here for dependent drop-downs:
http://www.contextures.com/xlDataVal02.html

Hope this helps.

Andy.

"Varun" wrote in message
...
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.