merge database or sort?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anand - 16 Jun 2007 02:44 GMT

I don't know if there is a way to do this but if anyone can tell me, it would
save me days of work.

I have 2 sheets, one with many columns of numbers but one column with
identifier numbers (Sheet 1, column a) and anotehr sheet with with 2 columns
of #'s (sheet 2, column b and c).

Column A and Column B both contain common identifier #'s (column B only has
1500 of 3000 total while Column A has all 3000).

What I want to do is merge sheet 1 and 2 with the Sheet 2 two identifier #'s
matching positions (i.e. row) with the Sheet 1 identifier #'s.

Otherwise i will have to manually move data for 1300 cells from sheet 2 to
sheet one. Doable but tedious.

Any shortcuts?

Thanks

anand

Reply to this Message

JLatham - 16 Jun 2007 03:16 GMT

Can I ask you to describe it in slightly different fashion? As usual, I'm
having trouble visualizing the whole thing.

Perhaps like this:
I wish to copy information from sheet 1, columns x, y, z. to sheet 2,
columns q, r, s when value in column A on sheet 2 matches column B on sheet 1.

or
I wish to copy information from sheet 1, columns x, y, z. to sheet 2,
columns q, r, s when value in column A or B on sheet 2 matches column B on
sheet 1.

> I don't know if there is a way to do this but if anyone can tell me, it would
> save me days of work.
[quoted text clipped - 17 lines]
>
> anand

Reply to this Message

anand - 16 Jun 2007 07:28 GMT

OK, let's try this.

There is data in column A, C and D. I want a formula to place into a cell
in column B.

If the value in column A (call it "x") matches any value in Column C (eg.
range $c$2:$c$1300), then insert value from column D into cell in column B.

For example, we're putting the formula in B3. In A3 the value is 222. The
formula in B3 would look for any value of 222 in C2:C1300 and return the
value to the immediate right of the match. So if the match is found in C888
and the value in D888 is 911, then B3 should return 911. If there is no
value in that position, it should just return a blank.

There will be only one match maximum between values in Column A and C. some
values in D will be blank.

> Can I ask you to describe it in slightly different fashion? As usual, I'm
> having trouble visualizing the whole thing.
[quoted text clipped - 29 lines]
> >
> > anand

Reply to this Message

CmK - 16 Jun 2007 06:07 GMT

Hi

I think you need to use the Vlookup function
make sure the #'s in sheet2 is sorted asc
If you have trouble figuring out the Vlookup function let me know i will
show you how

thanks

> I don't know if there is a way to do this but if anyone can tell me, it would
> save me days of work.
[quoted text clipped - 17 lines]
>
> anand

Reply to this Message

JLatham - 16 Jun 2007 06:24 GMT

I agree, it sounds like a VLOOKUP() will work, I'm just a bit confused on
what to use for matching and what columns from where should be returned.

> Hi
>
[quoted text clipped - 26 lines]
> >
> > anand

Reply to this Message

CmK - 16 Jun 2007 06:36 GMT

I guess the two identifers # in both sheets

> I agree, it sounds like a VLOOKUP() will work, I'm just a bit confused on
> what to use for matching and what columns from where should be returned.
[quoted text clipped - 29 lines]
> > >
> > > anand

Reply to this Message