excel

[Guest]

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(Mar!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,Mar!B8,IF(Mar!D9>=M18,Mar!B9,E18))))))))
=IF(Mar!D10>=M18,Mar!B10,IF(Mar!D11>=M18,Mar!B11,IF(Mar!D12>=M18,Mar!B12,IF(Mar!D13>=M18,Mar!B13,IF(Mar!D14>=M18,Mar!D14,IF(Mar!D15>=M18,Mar!B15,IF(Mar!D16>=M18,Mar!B16,IF(Mar!D17>=M18,Mar!B17,E16))))))))

 

[Guest]

Currently, excel can only nest to 7 levels. It looks like you are trying to
find the smallest value in Mar!D217 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!D217,1)+(VLOOKUP(M18,Mar!D217,1,TRUE)<>M18))