[newbe]

Hello I'm a bit stumped...I've attached a portion of my workbook for reference. What I'm trying to accomplish is this: in the "KANBAN Info" worksheet...column C...I'd like to search the value in column A from the "Info Sheet" in range...

Hello

I'm a bit stumped...I've attached a portion of my workbook for reference.

What I'm trying to accomplish is this:

in the "KANBAN Info" worksheet...column C...I'd like to search the value in column A from the "Info Sheet" in range ("E2:AJ100")...then return the value offset 64 columns to the right, but then repeat untill it finds every instance of the value from column A from the "KANBAN Info" sheet....ALL at the same time adding all of the values it finds together, creating a SUMMED value in the end.

I hope that make sense.

The COUNT column in the "KANBAN Info" sheet tells me how many instances of the value exist...but finding them all, and adding the values from the corresponding Daily Usage columns is a bit more complicated than I thought.

I know all about the VLOOKUP/HLOOKUP feature, among others...but I don't think that it is going to be that easy...but I do believe some type of a Macro in VB will do the trick...

Any help will be MUCH appreciated.

Attached Files Search Help.xls (72.5 KB)