vlookup or sumproduct ?
 

Hi,

Can someone please look into this ?
I need to fill in yellow cells from attrition chart below it,

Criterias:
They have to match the size then based on the QTY return the appropriate attrition.

https://docs.google.com/spreadsheet/...QVE8tRVpyR Wc

Thank you.