Help with nested IF function

Hi,

Need help in nested IF, I am able to get the desired values in different cells. Wanted to merge both the formulas and get it in single cell. Please help.

Thanks.

Formula:

=IF(E2>=B4,IF(E2<C4,D4,IF(E2>B3,IF(E2<C3,D3,IF(E2>B2,IF(E2<C2,D2,""))))))

Formula:

=IF(E2>=B5,IF(E2<C5,D5,IF(E2>B6,IF(E2<C6,D6,IF(E2>B7,IF(E2<C7,D7,""))))))

Not able to attach the sample work book.