Assuming you have a yable and the data is set up like

code1 value value etc
code2 value value etc

and so on

then you can use

=VLOOKUP(C1,Sheet2!A2:C50,2,0)

where C1 is the typed in lookup value (code) and A2:C50 the table and this
particular formula will return the value from column 2

lookup VLOOKUP in help


--

Regards,

Peo Sjoblom

Nothwest Excel Solutions

www.nwexcelsolutions.com

remove ^^ from email

"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey




"creo" wrote in message
...
How do I retreive data, which I've entered, from another worksheet when I
enter a code or # that is specific to that data?