We use VLOOKUP for that, Jacke. Try this:
http://www.officearticles.com/excel/...soft_excel.htm

And here's a sample file I made:
http://www.officearticles.com/freedls/pricelist.xls
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"jacke613" wrote in
message ...

I made a drop down menu with 3 choices. I want the rest of the worksheet
to be based on the choice made in the drop down menu.
For example, I have choices A, B and C in the drop down menu.
If A is selected, I want some set of information to appear.
If B is selected, I want a different set to appear.
Etc...

Please email me to help.

Thanks,

Jack


--
jacke613
------------------------------------------------------------------------
jacke613's Profile:
http://www.excelforum.com/member.php...o&userid=18581
View this thread: http://www.excelforum.com/showthread...hreadid=381353