information analysis

  • Thread starter Thread starter Mike Aiken
  • Start date Start date
M

Mike Aiken

Hi all,

I am trying to bring together sales information from 2003 and merge i
with information from 2004.

Table A is 2003 amd Table B is 2004. Both tables are 6 columns wide.

columns 1 and 2 on both tables are the part numbers and descriptions
and most part numbers feature in both tables, however some appear i
table A that are not in table B and some in table B are not in table A
initially i am try to merge the two sets of part numbers an
descriptions so i have one list.

The second part would be to import the sales information from table
and put in colums 3 to 6 and information from table b and put it i
columns 7 to 10 against the correct part numbers.

Can anyone please point me in the right direction.

Many thanks Mike :confused
 
Hi

Firstly, I would make a master list of part numbers/descriptions by copying
those columns from both tables and pasting them one under the other. To
de-duplicate this list, visit here:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

Once this is done, you can use a VLOOKUP() function to call in the details
from each of the tables.
So, in column 3 you'd have:
=VLOOKUP(A2,tablea,3,0)
=VLOOKUP(A2,tablea,4,0)
=VLOOKUP(A2,tablea,5,0)
for tha data from table A, and you can modify those formulas for table B

Hope this helps.
 
I suggest a VLOOKUP in both sheets to the other.
You will then get #N/A results for items not found
 
Hi Guys

Many thanks for the pointers, will have a go at the weekend.

Will keep you posted as to how i get on.

Thanks again Mik
 
Hi Andy,

Its taken me a bit longer to get to grips trying to put together m
spread sheet, but unfortunately illness knocked me back a bit.

However, i have tried over the last two weekends to get cracking on it
but unfortunately i have stumbled over the first hurdle.

The Url to pearsons was great, and i can see the theory of what i a
trying to do, but putting it into practice is causing a problem.

I have tried most of the options on that page, but i must be doing th
formulae wrong.

Anyway, is there a more idiot proof site for a beginner like me??

Or any other suggestions.

Thanks in advance.

Mik
 
Back
Top