My 4 input ranges are:
D2:M2; D5:M5; D8:M9; D13:M14
D2:M2 is either of 4 or 5 with a condition that maximum number of 5 occurrence will be one.
D5:M5 is either 0 or 1 or 2
D8:M9 & D13:M14 generates positive values.
Output cells are P10 & P11
P10=Corresponding D8:M8 analogous to the cell in which 5 is generated in D2:M2 provided ‘corresponding’ D5:M5=1
Or
P10=Corresponding D13:M13 analogous to the cell in which 5 is generated in D2:M2 provided ‘corresponding’ D5:M5=2
P11=Corresponding D9:M9 analogous to the cell in which 5 is generated in D2:M2 provided ‘corresponding’ D5:M5=1
Or
P11=Corresponding D14:M14 analogous to the cell in which 5 is generated in D2:M2 provided ‘corresponding’ D5:M5=2
P10 & P11=0 if D2:M2=4 (there is no 5)
P10 & P11=0 if the ‘corresponding’ cell in D5:M5=0
Formula required for P10 & P11
How to accomplish? Thanks in advance.
Bookmarks