Distribute values in columns based on match between two other columns

Hi All,
This is my first post. I need to figure out how to perform this analysis:

A has more rows than B-D. I have a subset of values in column B that I want to match with column A containing a master list of values. Based on the match, I want column C values and column D text values to distribute in two new columns according to A.

In C, there may be multiple values that match to B (and A), in which case I want the value in the new column to be a sum.

It gets more complicated in D. For this column, if the word is the same per match to B value, I want the same word to return to one column. If there are two or more words associated with the B value, is there a way to distribute the additional word into multiple columns?

Thanks for your time!ExcelForum_question_20130311.xlsx

Hi Jacc,
I have solved the second half of my problem by parsing the numerical value into multiple columns by the text value, for instance in the attached file IF(AND($C2>0,$D2="Planebed"),$C2,""), where "typeA" is replaced by "typeB" in the next column over.

But I have not yet figured out how to distribute the results in columns E and F (to columns G and H) to match up with the cell positions of A when A matches B.

I've attached a new file with the above result and have manually arranged a few data points the way I want the result to turn out, as you suggested. Any ideas?

Thanks!

Hi Jacc,
Thanks so much! I've had a quick look at the file and it appears that it will do the trick. Thanks also for showing me two ways to arrive at the solution. I've never used LARGE or MAX, and have never used the column headings in a function. Either way it would have taken me forever to get to this spot myself. I don't have quite enough time to get entirely through your solution until Friday. I will post again then with a final spreadsheet showing results, and will at that time mark my problem as solved, with your help