See if this helps:

http://contextures.com/xlDataVal02.html

Biff

"Vyr" wrote in message
...
I have a spreadsheet in which I already have column for drop-down lists.
What I need to know, is how do I make an IF statement that will read from
the
previous drop-down list and then give a new drop-down list of categories
for
the result of the previous list.

Or simply, how do I get an =IF to return a drop-down list as a result?