Go to help and read about VLOOKUP; then try it.
If you have a problem with it please come back for more info.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"excel beginer" <excel wrote in message
...
I am doing data entry everyday ~~i am thinking there is smarter way to do
this other then retype all the time.

example
a b c d
id # name trade code
1 1234 john tech
2 5678 tim farmer
3 2345 leo suervisory
4 4567 pat clark

is there anyway i can set up so every time i type in their id# then their
name,trade and code will come up

need to be simple so i can please
thank you