Need Help with Match and index function please.

1) Table with columns A, B, C and D with,
Cell A1 having a text Product,
Cell A2 having a text Cot12,
Cell A3 having a text Cot4,
Cell A4 having a text CGC,
Cell B1 having a text Pro1,
Cell B2 having a number 1000,
Cell C1 having a text Pro2,
Cell C3 having a number 1500,
Cell D1 having a text Pro3.,
Cell D4 having a number 500.
2) Another table with Column Q, R and S with
Cell Q1 having a text PROC,
Cell Q2 having a text Pro1,
Cell Q3 having a text Pro1,
Cell Q4 having a text Pro2,
Cell Q4 having a text Pro3,
Cell R1 having a text LTR,
Cell R2 having a number 1000,
Cell R3 having a number 1500,
Cell R4 having a number 500.
Cell S1 having a text Product,
3) what excel formula to be used in cell S2 to search the column and rows of cells A1 to D4 and match the value of cell Q2 and R2 and get the corresponding value from column A
4) what excel formula to be used in cell S3 to search the column and rows of cells A1 to D4 and match the value of cell Q3 and R3 and get the corresponding value from column A
5) what excel formula to be used in cell S4 to search the column and rows of cells A1 to D4 and match the value of cell Q4 and R4 and get the corresponding value from column A
Please see the attachment 1
Thanks,