Return list between rows

[Addis2912]

Hi all

This is my fist post an I have an ok understanding of excel

I have a table and I would like a formula to return a list between 2 rows.

I have hopefully attached a dummy spreadsheet showing what I would like returned.

I hope that I make sense with the example I also understand that the return would be in more than 1 cell potentially

Thanks in advance

Excel 2007 being used

I have now solved my query by adding a few helper columns thanks all

[dosydos]

you could try this formula

=CONCAT(INDIRECT("E"&MATCH($B$13,$B$1:$B$11,0)&":E"&MATCH($B$14,$B$1:$B$11,0)))


******EDIT: I just realized you are using excel 2007. This WILL NOT work with that version as CONCAT was not a formula for that version.

[Ace_XL]

Try

=CONCAT(INDEX($E$3:$E$8,MATCH(B13,$B$3:$B$8,0)):INDEX($E$3:$E$8,MATCH(B14,$B$3:$B$8,0)))

[Addis2912]

Thanks I have tried it but it just returns #NAME