Hi Wade, Instead of vlookup, I think validity is good for this kind of data manipulation.
Open a calc sheet and click the B column then , in the Menu select Data, scroll down to Validity and click it, a new window opens. Click on All Values and select 'list' This opens a new window. Type in the items you want on the list. After you type the first one, hit enter and enter the next one....and so on. Click OK to finish. Click B1 to see your drop down list. And instead of clicking 'list' you can use range. You should be able to create what you want from the example. Howard On Sun, 20 Apr 2025 at 08:27, Wade Smart <[email protected]> wrote: > 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 > -- 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
