Apache OpenOffice Community Forum

Hello all,

I have tried searching for help through the forums and google and was not able to find anything to help me create a dropdown menu that when I select the food item, it will auto-fill the row.

I have a table of items that I would like to use in my meal plans on the same spreadsheet or a new one. In my picture ideally, I would like to have all of the meat/fish items in a dropdown menu in A13 and once selected, will fill B13 to G13 with the item information. Is this possible?

So far all I can create is a dropdown menu by selecting A2:A8:G2:G8 and then Data>Validity>All Values and then selecting A13:A25:G13:G25 then Data>Validity>Cell Range>Source $Sheet9.$A$2:$G$8. This method requires me to manually select all the information IE amount, cal, etc.

I am really tired and hope that I am making sense hahah. I appreciate any help on how I can improve my meal spreadsheet.

Kind regards,

JK

Welcome to the forums.
I'd suggest changing your dropdown list so that it just uses the information in A2:A8
Then use VLOOKUP with the search criteria being the entry in the dropdown box and the range being A2:G8.

Off topic, I suggest you correct your forum signature, as OpenOffice does not (yet) have a version 6.0.1.1, thus either the version number is incorrect or you are using something other than OpenOffice...I suspect LibreOffice.

The array function =INDEX(rectangle ; MATCH(validated_cell ; column ; 0)) [Ctrl+Shift+Enter] returns the first row from the rectangle where the validated cell matches exactly the specified column.

based on your screenshot: =INDEX($B$1:$G$8 ; MATCH( A25 ; $A$1:$A$8 ; 0)) [Ctrl+Shift+Enter]
The source of the validated cell should be $A$1:$A$8

Hello,

Yes, sorry I am using librecalc. I'm sleep deprived at the moment and clearly not paying attention. I will update my signature and try out your advice out during the weekend and will post back as soon as i've figured it out.

Thanks again for your help.

Kind regards,


J