Lookup and return cell value

That's not a great format to work with, but you need something like this.

@0EGO,

Great Job, my friend!

Once again, you have demonstrated to not only look at the given, but rather the solution. And that initially lies within the build of the WorkBook, which you have so nicely fixed.

I myself, would not have been able to do it better.

Thank you for helping once again!

@ jenwantz,

So the solution turned out to be SumProduct and not Dsum, and some restructuring !...

Come on now, you have to agree. OnErrorGoto0 deserves a good Rep for his help!