How to put together data from two different excel files?
 

I have one file with a column of items and a column of prices. I have another
file with items, monthly sales amounts plus some other information. Because
there's other information, there are 4 rows for each item, but the monthly
sales amount is always the first of the 4 rows. So it looks something like
this

item A jan sales feb sales mar sales
item A info1 info2 info3
item A etc1 etc2 etc3
item A data1 data2 data3

and repeats for item B,C and so on.

I want to end up with sales amounts for the items in the first file. Not all
the items in first file will be found in the second file and vice versa.

I want the final product to be the first file with items and prices and
sales amounts for whichever months I choose, e.g. 6 month period or the whole
year.

How to put together data from two different excel files?
 

Vlookup(#number,other worksheet(range), column you want, false)
since what you want is always on the first row, this should work, returns
N/A if it can not find the #number in the second sheet.
--
David


"Hobbes2006" wrote:

I have one file with a column of items and a column of prices. I have another
file with items, monthly sales amounts plus some other information. Because
there's other information, there are 4 rows for each item, but the monthly
sales amount is always the first of the 4 rows. So it looks something like
this

item A jan sales feb sales mar sales
item A info1 info2 info3
item A etc1 etc2 etc3
item A data1 data2 data3

and repeats for item B,C and so on.

I want to end up with sales amounts for the items in the first file. Not all
the items in first file will be found in the second file and vice versa.

I want the final product to be the first file with items and prices and
sales amounts for whichever months I choose, e.g. 6 month period or the whole
year.