Return Desired Range of Table

[BadMamaRussia]

Hello,
I need to return a specific data set between two input values. See attached image. The output was manually input for the screenshot, but is there a formula I can use to calculate the output so that when I input values, it will always pop up with the correct data set. Thank you.

http://imgur.com/a/VCxR2

[AlKey]

Enter array formula in D8 and copy across to E8 and down

Please Login or Register  to view this content.

***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

[SlipEternal]

If you want to avoid array formulas, you can use a helper column. Add an additional column as the leftmost column (Column A).
In A1, enter the formula:

Please Login or Register  to view this content.

In A2, enter the formula:

Please Login or Register  to view this content.

Copy that formula to each empty cell in Column A (so that if there is something in column B, there is a formula in column A). Then, in cell E8:

Please Login or Register  to view this content.

Copy that to cells E8:F12.