Merging Data in Common

Here is my dilemna....

I have two spreadsheets that have one set of data in each column in common.... simply put it is a number.

From the one spreadsheet, I want to pull the column that is to the right of the number in column and merge it with the other data.

I am trying to figure out a formula that will accomplish this... I have attached a file to show the two spreadsheets and my end result I would like to have.

try this in B2 of the End Result sheet

=VLOOKUP(A2,Sheet1!$A$2:$D$2,2,0)

I have also do up the formula for you for the others fields in the attached
I have change the SKU to teat in Sheet2 for the formulas to works
Pls note that your data need to be consistent in all your dataset, either real numbers
or text that look like numbers

HTH

cheers, francis

Thanks for your help... Sorry, I screwed up, I need Price to be on the end result... is the change close to the same?

see attached

just change the column index number to 3
=VLOOKUP(A2,Sheet2!$A$2:$D$2,3,0)

Like JB have mentioned, this will look for exact match
A more robust lookup formula is Index and Match
I'll leave it to you to explore.


cheers, francis

I appreciate the formula and yes I cannot get it to work because it seems like the "SKUS" are formatted in two diiferent ways. They are being pulled from two different files. Any idea what is going on with this? I cannot put my finger on it, at all!

go to col A of sheet1
you will see a small green triangle which we call smart-tag
on all cells that is formatted as text
see attach pic.
select the range and click on arrow of the smart-tag
select convert to number

hope this help

cheers, francis

I am operating in Excel 2000, I don't think it has this function or does it? I think I have access to 2003, does that have the feature?

Hi

assuming your SKU start from A2
try placing this formula in a empty cells, let say G2 and copy down
=VALUE(A2)
then copy the G2 and down to the last cell with data in the column
go to A2 and paste special >> value
delete data in Col G

note: if you are not familiar with this, make a back up copy first.

version 2003 does have this feature

HTH

cheers, francis

OK, I posted another spreadsheet with the numbers on there and the SKUS that "look" exactly the same but don't seem to work. I simplified it two lines even though the master file has hundreds of items...

Any ideas from this sheet?

I appreciate all the help as this is very important to me!

Hi

Glad that this works for you.

If your question has been answered, please mark this thread as [SOLVED] by following these instructions:
- Go to the first post - Click edit - Click Advanced - Just below the word "Title:" you will see a dropdown with the word [No prefix]. - Change to [Solved] - Click Save

If you are happy with the results, please give my reputation a boost by clicking the blue scales icon in the upper right portion of the blue bar of this post.

cheers, francis