excel
How can I join the two in to one string will only let me go to b9
=IF(Mar!D2=M18,Mar!B2,IF(Mar!D3=M18,Mar!B3,IF(Ma r!D4=M18,Mar!B4,IF(Mar!D5=M18,Mar!B5,IF(Mar!D6= M18,Mar!D6,IF(Mar!D7=M18,Mar!B7,IF(Mar!D8=M18,Ma r!B8,IF(Mar!D9=M18,Mar!B9,E18))))))))
=IF(Mar!D10=M18,Mar!B10,IF(Mar!D11=M18,Mar!B11,I F(Mar!D12=M18,Mar!B12,IF(Mar!D13=M18,Mar!B13,IF( Mar!D14=M18,Mar!D14,IF(Mar!D15=M18,Mar!B15,IF(Ma r!D16=M18,Mar!B16,IF(Mar!D17=M18,Mar!B17,E16)))) ))))
|