about data entry please help

[excel beginer]

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

 

[Bernard Liengme]

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

 

[excel beginer]

thank you ~~

i have been looking in help and kind of have the idea that "vlookup will be
the one to use but i ahve try before and is not working for me

could you be so kind to make a sample useing the table below

thanks

also one other question what should if i went the total of the code 102
hours
and total of the code 101 hours.....
please use a smaple formula too

thank you again ~~

 

[Bernard Liengme]

Starting in A1 of Sheet2 enter
NAME TITLE CODE
john tech 101
tim farmer 102
leo supervisor 101
pat clerk 101

On Sheet 1 if B2 has the name "john",
then in C2 enter =VLOOKUP(B2,Sheet2!$A$2:$C$25,2,FALSE)
to get "tech"
In D2 enter =VLOOKUP(B2,Sheet2!$A$2:$C$25,3,FALSE)
to get 101
best wishes

 

[excel beginer]

thank you ~~
i got it to work now and it's so much better