adding values from another worksheet by matching criteria

Hi
not quite sure how you want to add the two sheets (probably either
vLOOKUP or SUMIF is what you're looking for). Can you post some example
rows (plain text - no attachment please) for both sheets and your
expected result

--
Regards
Frank Kabel
Frankfurt, Germany

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

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

One has a list of names (individual animals) and a matrix of info.
The other is similar, but has several columns of additional info.
The
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
name
list.

So, what I want to do is on worksheet 1, use the name in the a column
as standard, and to look at the other worksheet cell in column a ,
and
if the name in column a matches, have it add the values of 5 columns
in the 700 name worksheet to the 300 name worksheet in blank columns
I
have set up. Thus, say for my 300 name list, look at the list with
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
the
700 list. There may be 240 names on the 300 name list that are on
the
700 name list.

Again, my apologies...but I'm hitting the wall.


---
Message posted from http://www.ExcelForum.com/

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.


---
Message posted from http://www.ExcelForum.com/

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)


--
Regards
Frank Kabel
Frankfurt, Germany
"mangodance " schrieb im
Newsbeitrag ...
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.


---
Message posted from http://www.ExcelForum.com/