Nel post
*Dawn* ha scritto:

Thanks to all of you! However, I don't think I explained it very
well. I actually have two spreadsheets; the first as detailed below,
and the second one looks like this.

Column A Column B
Frame XXX
Assy 1 XXX
Build XXX
Assy 2 XXX
Etc

In the second worksheet, I need to create a formula that will look
for each item in Column A in the first worksheet and populate Column
B with the amount listed next to the matched Department. Vlookup
works very well for all except the Build one because it has multiple
entries in the first worksheet that need to be added together. I'm
sorry I didn't explain this better the first time. I just figured
you all knew what was in my head!! :)

Thanks!!


You have just to modify the formula; put this formula in B2 of your second
sheet and fill down:

=SUMIF(Sheet1!A2:A4,A2,Sheet1!B2:B4)

--
Ciao

Franz Verga from Italy