Cross Reference and Populate/Merge

[stussy5555]

Hi all, I would appreciate any tips you can give me on how to accomplish the following:

I have an Excel file that contains 2 unique sheets. There is one column in both sheets that have the same type of data: 4-6 digit numbers.

What I am trying to do is cross reference the numbers from sheet 1 and populate sheet 2 with data from sheet 1, based on the matching the number.

For example Sheet 1 columns, looks kind of like this:

ID | Name | City | State | Country

Sheet 2 columns, looks kind of like this:

ID | Keyword | Headline | Description | URL

Here is what I would like the end result to be:

ID | Keyword | Headline | Description | URL | Name | City | State | Country

Obviously this is sort of a merge based on grabbing information from one sheet and adding it to the other based on the ID. The thing is that Sheet 1 has 1 row per ID and Sheet 2 has multiple rows for each ID, and on Sheet 2 I need each and every row populated.

I am willing to pay someone to help me do this as well.

Thank you all.

[ConneXionLost]

Hi stussy5555,

Try this on sheet2 cell F2:

=VLOOKUP(Sheet2!$A2,Sheet1!$A$1:$E$25,COLUMN(Sheet1!B$1),0)

modify the ranges as necessary, then copy across and down.

Cheers,

[stussy5555]

Hi stussy5555,

Try this on sheet2 cell F2:

=VLOOKUP(Sheet2!$A2,Sheet1!$A$1:$E$25,COLUMN(Sheet1!B$1),0)

modify the ranges as necessary, then copy across and down.

Cheers,

I tried that and got a #REF! error. I kept the formula as you have above except for modifying the ranges. Any ideas?

Thanks

[ConneXionLost]

Hi stussy5555,

It's probably the sheet names or cell locations; any chance you could attach a sample spreadsheet? I'd be easier to write the formulas if I can see what you're working with.

Cheers,