Anyone help please

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.

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(VLOOKUP(A13,Sheet5!$A$3:$C$8,3,FALSE)),"","
" &
VLOOKUP(A13,Sheet5!$A$3:$C$8,3,FALSE))&IF(ISNA(VLOOKUP(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
>
>