See if this helps:

http://contextures.com/xlFunctions02.html

There's also info about creating drop down lists. Here's the site index:

http://contextures.com/tiptech.html

There's a wealth of info.

Biff

"Grumpy" wrote in message
...
I made an invoice in excel, and to make life easier does anyone know how to
make a list using multiple columns, I.E column headings are Item ID,
Description & Price. I want to put in th Item ID in a dropdown list, and
have
the other two columns enter the corresponding data.