populate cells based on multiple criteria

WHat values do you expect. The stuff from the matrix to the right or something else?

Please manually add the results you want so that we know the goal.

Sorry that's still not clear, at least to me.

Exactly what do you want to see in K14? Is that $54.95 from the big matrix, or 24 x $54.95 or something else?

Knowing what you expect is vital to our understanding of what you expect and avoids us guessing or assuming


Remember that when you ask a question in a forum those of us who might be able to help know absolutely nothing about your system and work process or the terminology you use. Unless you have uploaded a workbook we know nothing about how it is laid out and little about what you want done with it or how the results should be presented.

Whilst these things are second nature to you since you live with the workbook all the working day we start with zero knowledge so you need to take us by the hand and explain in quite precise detail your aims and goals as well as stuff like how your data might look different in other situations.
Don't assume we are able to "figure it out". We're usually quite good but not psychic.

Put yourself in our position and think about whether what you've posted makes sense and is unambiguous to someone who's never seen it before.
You are asking us for help so help us to be able to help you by providing all the information we need, even if that information seems obvious or intuitive to you.