validating a list of multiple columns

[Guest]

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.

 

[T. Valko]

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