If you want to return information from a table, you can use the VLOOKUP
function. For example, select a product number from a dropdown list, and
in adjacent cells, you can show the product name and price, from a
product list.

There's information on VLookup in Excel's Help, and he

http://www.contextures.com/xlFunctions02.html

macbr549 wrote:
Im trying to figure out how to change the info in a few other cells when i
change a number in a drop list in Excel.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html