Merging Document Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DeperateNumbers - 24 Sep 2007 22:14 GMT

I have a number in column B of Worksheet A. I'm trying to locate that same
number from Worksheet B, column A. Once I have found corresponding numbers,
I want to pull the information from column C, Worksheet B into Column C
Worksheet A. And then repeat for mulitple rows. Can you please help?

Reply to this Message

JW - 24 Sep 2007 23:00 GMT

On Sep 24, 5:14 pm, DeperateNumbers
<DeperateNumb...@discussions.microsoft.com> wrote:

> I have a number in column B of Worksheet A. I'm trying to locate that same
> number from Worksheet B, column A. Once I have found corresponding numbers,
> I want to pull the information from column C, Worksheet B into Column C
> Worksheet A. And then repeat for mulitple rows. Can you please help?

In cell C2 of Worksheet A, place this and paste down as needed.
=VLOOKUP(A2,'Worksheet B'!A:C,3,FALSE)

Reply to this Message

Peo Sjoblom - 24 Sep 2007 23:11 GMT

It won't really transfer all information just the first occurrence unless
the
numbers are all unique

Signature

Regards,

Peo Sjoblom

> On Sep 24, 5:14 pm, DeperateNumbers
> <DeperateNumb...@discussions.microsoft.com> wrote:
[quoted text clipped - 7 lines]
> In cell C2 of Worksheet A, place this and paste down as needed.
> =VLOOKUP(A2,'Worksheet B'!A:C,3,FALSE)

Reply to this Message

JW - 24 Sep 2007 23:01 GMT

On Sep 24, 5:14 pm, DeperateNumbers
<DeperateNumb...@discussions.microsoft.com> wrote:

In cell C2 of Worksheet A, place this and paste down as needed.
=VLOOKUP(A2,'Worksheet B'!A:C,3,FALSE)

Reply to this Message