Dropdown box in calc, mutliple columns

users
#1

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

#2

Yes. There are two things to do here: setting up a drop-down menu from which values in column X can be selected, and then arranging that the appropriate values appear in column Y.

o Select column X (or an appropriate range of it).
o Go to Data | Validity... | Criteria.
o For Allow, select "Cell range".
o For Source, enter A$1:A$99 (or whatever).

Now each relevant cell in column X will have a drop-down selection list, from which to choose each entry.

o In Y1, enter =VLOOKUP(X1;A$1:B$99;2;0) and fill or copy this down the column.

I trust this helps.

Brian Barker

#3

Hi :slight_smile:
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! :slight_smile:
Regards from
Tom :slight_smile: