adding values from another worksheet by matching criteria

  • Thread starter Thread starter mangodance
  • Start date Start date
M

mangodance

I know this has to be really basic but I'm running on empty and don'
seem to be able to hammer it out.

What I have is an excel file that contains two worksheets...one buil
from a spreadsheet in another file.

One has a list of names (individual animals) and a matrix of info. Th
other is similar, but has several columns of additional info. Th
problem is the 2nd sheet has 2X the number of names in the "a" column.
Additionally, all of the names in the 300 list are not on the 700 nam
list.

So, what I want to do is on worksheet 1, use the name in the a colum
as standard, and to look at the other worksheet cell in column a , an
if the name in column a matches, have it add the values of 5 columns i
the 700 name worksheet to the 300 name worksheet in blank columns
have set up. Thus, say for my 300 name list, look at the list wit
700, and add data from corresponding cells into the 300 name list.

BTW, no names are duplicated on the 300 list, nor are there any on th
700 list. There may be 240 names on the 300 name list that are on th
700 name list.

Again, my apologies...but I'm hitting the wall
 
Sheet 1 (w/300 names)

column A is a list of names (text)
column B is a list of dates
column C is a list of states (text)
column D is a list of counties (text)
column E is a list of numbers
column F is a list of numbers
column G is a list of numbers

I want to add:

column H is a list of habitats (text)
column I is a list of numbers
column J is a list of numbers
column K is a list of numbers
column L is a list of numbers


Sheet 2 (w/700 names)

column A is a list of names (text) - like sheet 1, but more names...and
not all in sheet 1 are in sheet 2)
column B is a list of habitats (text)
column C is a list of numbers
column D is a list of numbers
column E is a list of numbers
column F is a list of numbers


I want it to look in sheet 1, column A and use each name to look in
column A of sheet 2. Where present, I want the data in the columns
BCDEF of sheet 2 to fill in coulmns HIJKL on sheet 1. Again, not all
names in sheet 1, column a are represented ion sheet 2 column a. also,
there are twice as many names in sheet 2, column a as in sheet 1,
column a.
 
o.k.
try the following formula in I1 (don't know how you want to 'add' text
values but for numbers the following would do):
=SUMIF('sheet2'!$A$1:$A$700,$A1,C$1:C$700)
copy this down and to the right. This will return the sum vor your
matching entries in sheet 2 (and a zero for non matches)
 
Back
Top