Excel Lookup

[Ginny]

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!

 

[Gary''s Student]

Use the VLOOKUP() function. See:

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