Return multiple row labels

I have various assessment data (school based), which, depending on the specifics of, I wish to return the row label, plus specific other adjoining cells within said row.
E.g.
Name Target WA AOB Result
Adam Smith 6c 5a O -1
Billy Jones 5b 5b A 0
Charlie Thomas 5c 5a A 2
Dan Thompson 6c 5a O -1

I already conduct some basic analysis of the data relating to the Target and WA codes 4a, 4c etc, and this returns a Result as indicated which can be zero, positive or negative. Depending on the value of this number, I would then want to return, on a separate sheet, the Name (row label?), Target, WA & AOB values for the corresponding row.

E.g. If 0 then
Billy Jones 5b 5b A

If -1 then
Adam Smith 6c 5a O
Dan Thompson 4b 3a O

Can anyone help with this?

Hi,

Try this.

Regards

Wow! Thank you so much!!! That is better than I imagined. You have no idea how much time that will save me and so many of my colleagues!!!l
I'll have to work out how to use SMALL and ROW as have no idea what they do. Until I can properly understand what you've done I'll be able to adapt that easily enough, thank you, thank you, thank you.

Glad I could help.

This link will help you to understand the formula.

http://office.microsoft.com/en-us/ex...001226038.aspx