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

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

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" wrote:

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 e
id # name trade code hours
1 1234 john tech 101 2
2 5678 tim farmer 102 5
3 2345 leo suervisory 101 6
4 4567 pat clark 101 2.5

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

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"excel beginer" wrote in message
...
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" wrote:

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 e
id # name trade code hours
1 1234 john tech 101 2
2 5678 tim farmer 102 5
3 2345 leo suervisory 101 6
4 4567 pat clark 101 2.5

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

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


"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"excel beginer" wrote in message
...
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" wrote:

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 e
id # name trade code hours
1 1234 john tech 101 2
2 5678 tim farmer 102 5
3 2345 leo suervisory 101 6
4 4567 pat clark 101 2.5

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