sumif with nested vlookup

Hi,

I have a spreadsheet that contains the full list all of our items in inventory.
For each job, I import a list of items and quanity of each item used.

On the inventory list I am using vlookup to match up the items in the import sheet and display the quanity.

Please Login or Register  to view this content.

So far so good but now i realize that I will sometimes have more than one entry on the import sheet that matches the criteria. Now I need the total to add all matching items.

I can use sumif on the import page but it would be alot cleaner if it could be accomplished in combination with the vlookup.

Thanks in advance for any ideas.

Thanks Dave.

Works great

The only thing of minor concearn (if I understand this correctly) is that a maximum number of matches has to be predetermined.

Please Login or Register  to view this content.

So, if I figure that the worst case scenario will have maybe 10 entries for the same item, I cover 20 instances to be safe. Now, on some hot august day in hell, there happens to be 21

Did I understand it correctly?

I was also looking at the sumproduct function but I had trouble wrapping my head around it.

Looks a little overcomplicated to me - just use SUMIF

=SUMIF(IMPORT!$A$2:$A$200,$B2,IMPORT!$H$2:$H$200)

Thanks for the input

That is what i had originally done but I had it separate on the import sheet.

I was looking for a way to incorporate it in my vlookup on the static inventory sheet because the import sheet gets overwritten.

The SUMIF formula I posted should go on the inventory sheet, doesn't that do what you want?

Sorry, I wasnt paying attention ...duh

I got going down a path and couldn't see the forest for the trees.

Thanks for the help(and the additional smack on the head I needed)