complex spreadsheets!

[squishee]

Hello,

I am trying to create i user friendly spreadsheet that does seemingly complex things.

What i would like is for someone to enter a numerical code into column f in worksheet1, which has a data validation list pulled from worksheet2. When they do this i would like column g in worksheet1 to be populated with text from another column in worksheet2.
For example

someone would enter into column f = 123
column g would then populate with specatcles

is this possible, if so how??

thanks

 

[VoG]

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