Anyone help please

  • Thread starter Thread starter mister z
  • Start date Start date
M

mister z

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
 
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide data based on future date 1
I want to get the sum of a total number of fields on a weekly basis. 3
Format(Time, "h.mm AM/PM") question 4
Date Sorting 2
Excel Chart displays incorrect X-Axis 2
Macro or other code for deteming Months, Years, Quarter based on d 4
turn off pivotfield sort 1
Lookup Values 2 Vertical variables 1

Back
Top