Use the VLOOKUP() function. See:
http://www.contextures.com/xlFunctions02.html
--
Gary''s Student - gsnu200789
"Ginny" wrote:
I have a worksheet with a dropdown list of item codes in Col A.
Once that the code is selected, I need the item description in Col D and the
item price in Col F.
I have a seperate worksheet that has 3 columns for the code, description,
and price.
Thanks!