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: [email protected] 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
