about data entry please help
 

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

about data entry please help
 

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

about data entry please help
 

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

about data entry please help
 

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

about data entry please help
 

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