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)))) ))))

Currently, excel can only nest to 7 levels. It looks like you are trying to
find the smallest value in Mar!D2:D17 that is greater than or equal to M18
and return whatever is in Mar!B2:B17. See if this helps.

=INDEX(Mar!B2:B17,MATCH(M18,Mar!D2:D17,1)+(VLOOKUP (M18,Mar!D2:D17,1,TRUE)<M18))



"dhawk001" wrote:

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)))) ))))