Difficult task for me - dont know how to explain

[garfiola]

I have this problem with csv

for example i have product excel that looks like this

first column PRODUCT ID

second column PRODUCT NAME

Third COLUMN PRODUCT PRICE


and I want to add 3 more columns to that excel
META TITLE
META DESCRIPTION
META KEYWORDS


I sorted the first escel by PRODUCT ID, first column

Second excel is sorted same by product ID, all three columns are dependent on first column PRODUCT ID


So how to merge these two excels that the product IDS will be in the same row?

If I just copy and paste the second excel to first one, than the rows are misaligned, I can see that the PRODUCT ID ROWS do not match, are not in same row, so my whole excel is useless

Can somebody help how to merge these two excels depending on 1 COLUMN PRODUCT ID that both excel have?

MUCH APPRECIATED!!!!

 

[VoG]

Try VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[garfiola]

Try VLOOKUP http://www.contextures.com/xlFunctions02.html

I tried vlookup and consolidate

I failed both times

Again I will explain; i am trying to fix this for 5 hours and could not figure it out.

I opened first excel then second and created new third excel file.

I click on a1 fiels in Excel 3 and clicked data and consolidate

then i use sum function, i am not sure if that is correct and i dragged around all the fields

I clicked add

THen opened the EXCEL 2 file and did same thing, selected the fields that I want to join with excel 1


And selected left row as an option, not top row, only left row.


I failed, i got an error that the data is overlaying or something, nothing happened........


I dont want to join or sum fields together

I want to put the fields of the EXCEL 2 right of the fields of EXCEL 1

Nothing is sum, miltiplied, they are just data fields

AND MERGE THEM depending on the first left COLUMN that both EXCEL files have

Are you usere VLookup is the only thing, or is consolidate better?