In the excel file Match.xlsx (10.7 KB),
The input sheet Sheet1 looks like
The sheet having values Sheet2 looks like
The required output sheet output looks like
Here, When column “Quality and Series” of Sheet1 matches with column “Quality and Design Series” of Sheet2 then Assign Column A,B,C,D of Sheet1 values like A of Sheet1 = (Pro * A of Sheet2) and so on for other columns also where round the digits of output upto three decimal places.