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

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 <wadesmart@gmail.com> 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: 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

-- 
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