Excel IF AND BUT Function with Multiple Criteria

Hello everyone...

Although I have read and reread and tried the various formulas proposed on my side; I give up; Here is my situation.
Two sheets of information "Output" and "Rec"
On the "Output" sheet
6 columns B;D;E;F;G;H with information on about a hundred lines
column B = information "M" or "V" in each cell
columns D;E;F;G;H = numbers between "1" and "10" in each cell

6 columns M;N;O;P;Q;R which will have the sought formula that will display the information from the "Rec" sheet

On the "Rec" sheet the other information that will be retrieved to be displayed on the "Output" sheet due to the formula.
A1,B1,C1,D1 for information "Output" sheet cell B=M and A2,B2,C2,D2 for B=V

Formula in French in a "line 1" cell

If cell B1=M and cell D1=1 then "Rec sheet cell A1" BUT IF cell D1=2 then "Rec sheet cell B1".... and this continues until D1=10
But if cell B1=V and cell D1=1 then "Rec sheet cell A2" BUT IF cell D1=2 then "Rec sheet cell B2".... and this continues until D1=10

=if(and(B1=M;D1=1);Rec!=A1;if(and(B1=M;D1=2);Rec!=B1 ... etc up to 10 but I don’t know how to insert the BUT for if(and(B1=V;D1=1);Rec!=A2

Could you guide me in composing the formula because I'm overheating. "Laugh"

Thank you all...

Configuration: Mac OS X (10.11.6) / Safari 10.0