[libreoffice-users] Calc - populating a col with all matching avail items

My church asked me to fix their spreedsheet but I couldnt understand
all the values. But this is what they want.

The data:

Sheet 1
ColA = Category
ColB = Name
ColC  = Price paid
ColD = member or outside help

Sheet 2
B1 = Drop down list (supplies, service,utility)

C6 = Name
D6 = Price
E6 = Member


The result:

Sheet 2 B1 they want to use the drop down to select Supplies.
C7 would show the first supply named, D7 the price paid.

Or, B1 would be Service and C7 would show the name of the service
provided and the price paid.

They have other things they are adding to that drop down but the 
result is the same: see a list of all items in that category. I was trying
to do with vlookup but I cant figure out how the next line, C8,D8 get
the next item. The increasing index value.


-- 
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy