Combining Data (Want to connect 2 different sets of Column A data)

Hello, first off I am using Microsoft Excel 2011 for Mac.

Here is the issue I am having..

I have 2 excel workbooks of data. In both of them, Column A has a list of player names with a different set of data in each row.

What I want to do, is match up the player's to each other. So for example...

Cell A2 of the "2 Site Data" attachment has the name Jamal Crawford. I want to be able to pull Jamal Crawford's data from the "2013 Fantasy Data Sheet" and match it up with each other.

So for example, a final product would include each row having a player's name, their salary (from 2 Site Data), and the numbers (From "Fantasy Data Sheet")


I figured there's a function or a way I will be able to set it up where it searches for any other row's of data with what you type in and pulls that data.

The player name stated on "2 Site Data" & "2013 Fantasy Data Sheet" is different.

If you have the same player name on both files, then use VLOOKUP is the best.

Refer to the attachment sample, it might give you an idea.

Thanks to you both for suggesting VLOOKUP.

Hikari, thanks, and yeah I should have mentioned that. One is sorted by first name, and the other by last name. I assume that would be an issue?

If it is an issue, it's probably okay because I can find data that has it sorted correctly.

So, while one sheet says "Jamal Crawford" the other one says "Crawford, Jamal". If there is an easy fix to that (or it still is compatible) then I wouldn't have to try and find different data points that have that similarity.

Once again, thanks guys, you have figured out the tough part for me already.

Originally Posted by Hikari

The player name stated on "2 Site Data" & "2013 Fantasy Data Sheet" is different.

If you have the same player name on both files, then use VLOOKUP is the best.

Refer to the attachment sample, it might give you an idea.

Thanks for that attachment, it was really helpful.

I tried to make a sheet and apply that method, and it worked for my first column perfectly.

In Sheet "DD Import" I applied the VLOOKUP to Row "E". It worked great. (Copied over data from Row "B" in the "Web Import" sheet)

So, what I want to do is copy all the data from sheet "Web Import", Rows B-J. I was able to use the formula to move over B above correctly. I am now running into problems when I try and move the rest of the data (Cells in Rows C-J in "Web Import") to the F and on sheets in "DD Import".

Hi Jordan

The variable part is the column number. You can change according to your needs. Refer the attached

For column F, =VLOOKUP(A:A,'Web Import'!A:C,3,0)
For column G, =VLOOKUP(A:A,'Web Import'!A:D,4,0)

Can you see the formula change on 3 & 4? It is means which column's value you're "looking" in the data

Cool, just via this thread I was able to get done exactly what I envisioned.

Okay, LAST question coming (ha)...I believe this is going to be a VLOOKUP answer as well.

Okay, so the similar data here is Row A in "Stats" and Row B in "Product", they are both a list of team names.

What I want to do is have the specific number (Row B of "Stats") moved over to Row C of Product.

So each team basically has a value (Row B of "Stats") and I want to represent that value in Row C of "Product"

Thanks again, I was able to use all the help yesterday and expand on it, so hopefully I can do the same here.

Hi Jordan - It's piece of cake XD

Just change the source you use on the VLOOKUP. Instead of selecting the Player Name, you select the 'Opponent' on "Product" sheet, then, match with the 'TEAM' on "Stats" sheet. Done~

=VLOOKUP(B:B,Stats!A:B,2,0)

Hi Jordan

If you problem have solved, please mark the thread as Solved. It will be convenient to other users

How to mark a thread Solved

Option 1:
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.

Option 2:
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save