I am trying to pull information from one work sheet to another.

on one work sheet in colomn A there are several names and in column B there
are several numbers.

A B
1 frank 10
2 billy 5
3 carol 6
on a seperate work sheet

A B C D
1 frank ? carol ?
2 billy ? frank ?
I need for excell to look at sheet 1 for carol and put the number into the
? box

can someone help me

Put this in D1:

=VLOOKUP(C1,Sheet1!$A$1:$B$4,2,1)

You can copy it down, as well as into B1

Hope this helps.

Pete

On Jan 14, 7:04*pm, motorman2008
wrote:
I am trying to pull information from one work sheet to another.

on one work sheet *in colomn A there are several names and in column B there
are several numbers.

* * * * A * * * * * * * * * * * * B
1 * * * * frank * * * * * * * * 10
2 * * * * billy * * * * * * * * * *5
*3 * * * * carol * * * * * * * * 6
on a seperate work sheet

* * * * *A * * * * * * *B * * * * * * * *C * * * * * * *D
*1 * * * *frank * * * * ? * * * * * * * *carol * * * * *?
2 * * * *billy * * * * * ? * * * * * * * *frank * * * * *?
I need for excell to look at sheet 1 for carol *and put the number into the
? box

can someone help me

VLOOKUP is what you want. The formula may be slightly tricky at first to
learn, but there are other things to watch out for. If your spreadsheet
happens to have spaces after text in a cell vlookup will not work. So, keep
that in mind if you are wondering why everything you entered is perfect and
nothing is happening. Trim is a good function to know to help get rid of
spaces and such. =TRIM(A1)

"motorman2008" wrote:

I am trying to pull information from one work sheet to another.

on one work sheet in colomn A there are several names and in column B there
are several numbers.

A B
1 frank 10
2 billy 5
3 carol 6
on a seperate work sheet

A B C D
1 frank ? carol ?
2 billy ? frank ?
I need for excell to look at sheet 1 for carol and put the number into the
? box

can someone help me