What function do i use?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

motorman2008 - 14 Jan 2008 19:04 GMT

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

Reply to this Message

Pete_UK - 14 Jan 2008 19:21 GMT

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
<motorman2...@discussions.microsoft.com> wrote:

> I am trying to pull information from one work sheet to another.
>
[quoted text clipped - 14 lines]
>
> can someone help me

Reply to this Message

LiveUser - 14 Jan 2008 21:29 GMT

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)

> I am trying to pull information from one work sheet to another.
>
[quoted text clipped - 14 lines]
>
> can someone help me

Reply to this Message