Excel expert? I need help and will pay $$

[stussy5555]

Hey guys,

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 who can help me accomplish this task. Paypal to your account immediately.

Thanks

 

[stevendomz]

Hey guys,

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 who can help me accomplish this task. Paypal to your account immediately.

Thanks

Hey hi i can help you PM me, it could be better i you come online

 

[Bsod_]

Did you get this sorted Stussy? If not PM me, I've done tons of Excel work...

 

[DumDum]

How many rows are there on each sheet?

 

[rileypool]

I took care of it for him that night guys.

 

[sleepylee]

I took care of it for him that night guys.

But what about the Excel issue?

 

[erect]

I took care of it for him that night guys.

I know, I know ... I should be working

 

[turbolapp]

^^^lol

EDIT: the lol was intended for the post above Erects. Erect's post made me queasy which is so not cool when I'm on a treadmill and running to the bathroom might get me killed.

 

[rileypool]

And I didn't even require payment. I'm a man-whore what can I say. He liked the VLOOKUP() function.

I <3 WF.

 

[ck256]

yup - vlookup .. . hard to charge for that one and keep a conscious . .

 

[sidney]

i think i can help you to solve your problem,just PM me if you are interested...i am looking forward for it..,.

 

[jamman]

just get rid of it for the LOVE OF GOD!