Hi ...

I have a data file, and in another file, I would like to have the Product
Description pop up when I enter in the Product code in a cell.

Please help and thank you in advance.

Have a look at how to use the VLOOKUP() function. Also, have a look here to see
how to work with dependant dropdown lists...

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

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion