Hello everyone!
For several days I struggle with the problem of the sum found using VBA code indexes, each multiplied by it's own specific factor. Please find attached file as a example. In the first sheet 'rec' there is column 'POZ' contains sku numbers used to found assigned INDEX from 'fac' sheet. The csv search is carried out thanks to the VBA function LookupCSVResults explained here:

http://superuser.com/questions/53623...ultiple-values

Each 'POZ' sku number is assigned to one or several Indexes and each Index has it's own factor. Sheet 'qua' contains quantity of Index in the month. The problem is to find and sum quantity of all indexes for a defined 'POZ' in a given month, each separately multiplied by it's own factor.
It would be nice to be able to choose different months in the future.
I tried to solve the problem using solution found in this post:

http://www.excelforum.com/l/968735-asdf.html

but without success. Maybe there is some other way to solve this problem?
Thank you very much in advance for your interest.

Best regards,
uhlik

example.zip