I have 4 worksheets
MASTER SHEE
Project, Date, Sum of Description of change
100, 12/5/2006, Changed the Date and Changed the number
200, 12/5/2006, Changed the Date and Changed the number and Changed th
ship to
300, 12/5/2006, Changed the number
400, 12/5/2006, Changed the Date and Changed the number
500, 12/5/2006, Changed the Date and Changed the number
600, 12/5/2006, Changed the Date and Changed the number

SHEET
Project, Date, Description of change
200, 12/5/2006, Changed the Date
300, 12/5/2006,
100, 12/5/2006, Changed the Date
400, 12/5/2006, Changed the Date
500, 12/5/2006, Changed the Date
600, 12/5/2006, Changed the Date

SHEET
Project, Date, Description of change
200, 12/5/2006, Changed the number
300, 12/5/2006, Changed the number
100, 12/5/2006, Changed the number
400, 12/5/2006, Changed the number
500, 12/5/2006, Changed the number
600, 12/5/2006, Changed the number

SHEET
Project, Date, Description of change
200, 12/5/2006, Changed the ship to
300, 12/5/2006,
100, 12/5/2006,
400, 12/5/2006,
500, 12/5/2006,
600, 12/5/2006

The above sheets have three columns: Project number, date, Descriptio
of change. I would like to some how automate Sum of Description o
change (Column C) on Master sheet, to sum up the changes on sheet 2,3,
according to the project number. Note the project number is going to b
on different lines then the master sheet

--
mister
-----------------------------------------------------------------------
mister z's Profile: http://www.excelforum.com/member.php...fo&userid=2809
View this thread: http://www.excelforum.com/showthread.php?threadid=48334

It doesn't put the and in, it's long, and it uses sheets 4,5,6 instead of
sheets 1,2,3, but this seems to basically work:
=IF(ISNA(VLOOKUP(A13,Sheet4!$A$3:$C$8,1,FALSE)),"" ,VLOOKUP(A13,Sheet4!$A$3:$C$8,3,FALSE))&IF(ISNA(VL OOKUP(A13,Sheet5!$A$3:$C$8,3,FALSE)),"","
" &
VLOOKUP(A13,Sheet5!$A$3:$C$8,3,FALSE))&IF(ISNA(VLO OKUP(A13,Sheet6!$A$3:$C$8,1,FALSE)),""," " & VLOOKUP(A13,Sheet6!$A$3:$C$8,3,FALSE))

"mister z" wrote:


I have 4 worksheets
MASTER SHEET
Project, Date, Sum of Description of change
100, 12/5/2006, Changed the Date and Changed the number
200, 12/5/2006, Changed the Date and Changed the number and Changed the
ship to
300, 12/5/2006, Changed the number
400, 12/5/2006, Changed the Date and Changed the number
500, 12/5/2006, Changed the Date and Changed the number
600, 12/5/2006, Changed the Date and Changed the number

SHEET 2
Project, Date, Description of change
200, 12/5/2006, Changed the Date
300, 12/5/2006,
100, 12/5/2006, Changed the Date
400, 12/5/2006, Changed the Date
500, 12/5/2006, Changed the Date
600, 12/5/2006, Changed the Date

SHEET 3
Project, Date, Description of change
200, 12/5/2006, Changed the number
300, 12/5/2006, Changed the number
100, 12/5/2006, Changed the number
400, 12/5/2006, Changed the number
500, 12/5/2006, Changed the number
600, 12/5/2006, Changed the number

SHEET 4
Project, Date, Description of change
200, 12/5/2006, Changed the ship to
300, 12/5/2006,
100, 12/5/2006,
400, 12/5/2006,
500, 12/5/2006,
600, 12/5/2006

The above sheets have three columns: Project number, date, Description
of change. I would like to some how automate Sum of Description of
change (Column C) on Master sheet, to sum up the changes on sheet 2,3,4
according to the project number. Note the project number is going to be
on different lines then the master sheet.


--
mister z
------------------------------------------------------------------------
mister z's Profile: http://www.excelforum.com/member.php...o&userid=28099
View this thread: http://www.excelforum.com/showthread...hreadid=483343