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 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 <mistyha...@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+unsubscr...@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+unsubscr...@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