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

2014-02-18 Thread Tom Davies
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

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

2014-02-18 Thread Tom Davies
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 tomc...@gmail.com wrote: Hi :) I don't know but it sounds like it might be

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

2014-02-12 Thread Pat Brown
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