[Solved] Re: [libreoffice-users] Dropdown box in calc, mutliple columns

Hi :)
I've been told off-list that Brian Barker did give the right answer to
this.  Something to do with VLook-up apparently.  So, this q is
completely solved
Regards from
Tom :)



On 18 February 2014 09:19, Tom Davies <tomcecf@gmail.com> wrote:
> Hi :)
> I don't know but it sounds like it might be better to use a database
> program for this sort of thing.  Base is good when used with an
> external back-end.
>
> Please let us know what Operating System you are using (Xp, Win7,
> Ubuntu, Mac something or whatever).  Also might be good to know which
> version of LibreOffice you are using! :)
> Regards from
> Tom :)
>
> On 12 February 2014 13:36, Pat Brown <mistyhaven@gmail.com> wrote:
> > I have two columns in calc. Column A has a list of items while column B has
> > an associated cost. I want to be able to select from column A and have the
> > item entered into a form (say column X) but I also want to automatically
> > select the associated cost and have this entered into column Y, alongside
> > its associated item. Is this possible in Calc, and how would I then set
> > this up?
> >
> > Thanks,
> >
> > Paddy
> >
> > --
> > 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

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