[libreoffice-users] Calc, selecting from a list ? vlookup maybe ?

If i have a list over a number of columns how would i create a new list of
only certain rows from that list
Yes i know thats as clear as mud so i've attached a example spreadsheet
The column starting at B14 has membership type with (C14) a name next to it
- the actual sheet has more data.
Each row below has different membership type and associated data

I want new lists based on the membership type
The main list may be sorted changing the order of the rows 

Anyone know how i can do  this   
test1.ods <http://nabble.documentfoundation.org/file/n4144307/test1.ods>  



-----
IGraham

W764  LibreOffice 4.2.0.4
--
View this message in context: 
http://nabble.documentfoundation.org/Calc-selecting-from-a-list-vlookup-maybe-tp4144307.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted